DATADICT
| Order |
To_field |
Type |
Width |
Index |
Table |
Notes |
| 1 |
CERT_NO |
Character |
6 |
|
CERT1099 |
|
2 |
D_CERTIF |
Date |
8 |
|
CERT1099 |
|
3 |
NAME |
Character |
40 |
|
CERT1099 |
|
1 |
CONTROL_NO |
Character |
6 |
|
CCRE1099 |
|
2 |
NAME |
Character |
40 |
|
CCRE1099 |
|
3 |
SCORE |
Numeric |
7 |
1 |
CCRE1099 |
|
4 |
PASSED |
Logical |
1 |
|
CCRE1099 |
|
5 |
STATUS |
Character |
6 |
|
CCRE1099 |
|
1 |
CONTROL_NO |
Character |
6 |
|
FIRST |
|
2 |
OLDCONTROL |
Character |
10 |
|
FIRST |
|
3 |
CERT_NO |
Character |
6 |
|
FIRST |
|
4 |
D_ENTERED |
Date |
8 |
|
FIRST |
|
5 |
W_ENTERED |
Character |
8 |
|
FIRST |
|
6 |
D_MODIFIED |
Date |
8 |
|
FIRST |
|
7 |
W_MODIFIED |
Character |
8 |
|
FIRST |
|
8 |
NAME |
Character |
40 |
|
FIRST |
|
9 |
MAIN_ADDR1 |
Character |
40 |
|
FIRST |
|
10 |
MAIN_ADDR2 |
Character |
40 |
|
FIRST |
|
11 |
MAIN_CITY |
Character |
26 |
|
FIRST |
|
12 |
MAIN_STATE |
Character |
2 |
|
FIRST |
|
13 |
MAIN_ZIP |
Character |
10 |
|
FIRST |
|
14 |
MAIN_PHONE |
Character |
10 |
|
FIRST |
|
15 |
MAIN_EXTN |
Character |
7 |
|
FIRST |
|
16 |
MAIN_FAX |
Character |
10 |
|
FIRST |
|
17 |
MAIN_TYPE |
Character |
1 |
|
FIRST |
|
18 |
EMAIL1 |
Character |
40 |
|
FIRST |
|
19 |
WORK_FIRM |
Character |
40 |
|
FIRST |
|
20 |
WORK_ADDR |
Character |
40 |
|
FIRST |
|
21 |
WORK_CITY |
Character |
26 |
|
FIRST |
|
22 |
WORK_STATE |
Character |
2 |
|
FIRST |
|
23 |
WORK_ZIP |
Character |
10 |
|
FIRST |
|
24 |
WORK_PHONE |
Character |
10 |
|
FIRST |
|
25 |
WORK_EXTN |
Character |
7 |
|
FIRST |
|
26 |
WORK_FAX |
Character |
10 |
|
FIRST |
|
27 |
WORK_TYPE |
Character |
1 |
|
FIRST |
|
28 |
EMAIL2 |
Character |
40 |
|
FIRST |
|
29 |
ON_HOLD |
Logical |
1 |
|
FIRST |
|
30 |
DECEASED |
Logical |
1 |
|
FIRST |
|
31 |
BAD_ADDR |
Logical |
1 |
|
FIRST |
|
32 |
BOUNCED |
Logical |
1 |
|
FIRST |
|
33 |
D_BNC |
Date |
8 |
|
FIRST |
|
34 |
D_BNC_CLR |
Date |
8 |
|
FIRST |
|
35 |
DEL_DUP |
Logical |
1 |
|
FIRST |
|
36 |
BALANCE |
Numeric |
8 |
2 |
FIRST |
|
37 |
INACTIVE |
Logical |
1 |
|
FIRST |
|
38 |
DOB |
Character |
6 |
|
FIRST |
|
39 |
SSN |
Character |
9 |
|
FIRST |
|
40 |
PREF_ADDR |
Character |
1 |
|
FIRST |
|
41 |
REC_TYPE |
Character |
1 |
|
FIRST |
|
42 |
OTHER |
Character |
10 |
|
FIRST |
|
43 |
LATE_FEE |
Logical |
1 |
|
FIRST |
|
44 |
D_LRF_PAID |
Date |
8 |
|
FIRST |
|
45 |
CREDIT |
Logical |
1 |
|
FIRST |
|
46 |
D_REJ |
Date |
8 |
|
FIRST |
|
47 |
D_REJ_CLR |
Date |
8 |
|
FIRST |
|
48 |
NOTE |
Memo |
10 |
|
FIRST |
|
49 |
CHANGED |
Logical |
1 |
|
FIRST |
|
50 |
ARCH |
Memo |
10 |
|
FIRST |
|
1 |
NAME |
Character |
40 |
|
TEMPB |
|
2 |
DATE_COURS |
Date |
8 |
|
TEMPB |
|
3 |
COURSE_NO |
Character |
9 |
|
TEMPB |
|
4 |
LOC_CITY |
Character |
15 |
|
TEMPB |
|
5 |
LOC_ST |
Character |
2 |
|
TEMPB |
|
6 |
MAIN_ADDR1 |
Character |
40 |
|
TEMPB |
|
7 |
MAIN_ADDR2 |
Character |
40 |
|
TEMPB |
|
8 |
CITY |
Character |
20 |
|
TEMPB |
|
9 |
STATE |
Character |
2 |
|
TEMPB |
|
10 |
ZIP |
Character |
10 |
|
TEMPB |
|
11 |
POSTAL |
Character |
7 |
|
TEMPB |
|
12 |
PHONE |
Character |
10 |
|
TEMPB |
|
13 |
CAN_NO |
Character |
10 |
|
TEMPB |
|
14 |
ENTRY |
Character |
4 |
|
TEMPB |
|
15 |
AFF |
Character |
42 |
|
TEMPB |
|
16 |
AFF_OTHR |
Character |
7 |
|
TEMPB |
|
17 |
EMP_NAME |
Character |
40 |
|
TEMPB |
|
18 |
EMP_ADDR |
Character |
40 |
|
TEMPB |
|
19 |
EMP_CITY |
Character |
20 |
|
TEMPB |
|
20 |
EMP_ST |
Character |
2 |
|
TEMPB |
|
21 |
EMP_ZIP |
Character |
10 |
|
TEMPB |
|
22 |
EMP_POSTAL |
Character |
7 |
|
TEMPB |
|
23 |
RATE |
Numeric |
1 |
|
TEMPB |
|
24 |
IN_DBF |
Logical |
1 |
|
TEMPB |
|
25 |
CERTIF |
Logical |
1 |
|
TEMPB |
|
26 |
PROCESSED |
Date |
8 |
|
TEMPB |
|
27 |
ASID |
Logical |
1 |
|
TEMPB |
|
28 |
IDC |
Logical |
1 |
|
TEMPB |
|
29 |
IDEC |
Logical |
1 |
|
TEMPB |
|
30 |
IIDA |
Logical |
1 |
|
TEMPB |
|
1 |
CERT |
Memo |
10 |
|
RESU_MSG |
|
2 |
REVIEW_1 |
Memo |
10 |
|
RESU_MSG |
|
3 |
GENERAL |
Memo |
10 |
|
RESU_MSG |
|
4 |
REVIEW |
Memo |
10 |
|
RESU_MSG |
|
5 |
SCEN_0 |
Memo |
10 |
|
RESU_MSG |
|
6 |
SCEN_1 |
Memo |
10 |
|
RESU_MSG |
|
7 |
SCEN_2 |
Memo |
10 |
|
RESU_MSG |
|
8 |
SCEN_3 |
Memo |
10 |
|
RESU_MSG |
|
9 |
SCEN_4 |
Memo |
10 |
|
RESU_MSG |
|
10 |
SCEN_5 |
Memo |
10 |
|
RESU_MSG |
|
11 |
SCENNEW_0 |
Memo |
10 |
|
RESU_MSG |
|
12 |
SCENNEW_1 |
Memo |
10 |
|
RESU_MSG |
|
13 |
SCENNEW_2 |
Memo |
10 |
|
RESU_MSG |
|
14 |
SCENNEW_3 |
Memo |
10 |
|
RESU_MSG |
|
15 |
SCENNEW_4 |
Memo |
10 |
|
RESU_MSG |
|
16 |
SCENNEW_5 |
Memo |
10 |
|
RESU_MSG |
|
17 |
SCENNEW_6 |
Memo |
10 |
|
RESU_MSG |
|
18 |
THRD_0 |
Memo |
10 |
|
RESU_MSG |
|
19 |
THRD_1 |
Memo |
10 |
|
RESU_MSG |
|
20 |
THRD_2 |
Memo |
10 |
|
RESU_MSG |
|
21 |
THRD_3 |
Memo |
10 |
|
RESU_MSG |
|
22 |
THRD_4 |
Memo |
10 |
|
RESU_MSG |
|
23 |
THRD_5 |
Memo |
10 |
|
RESU_MSG |
|
24 |
THRD_6 |
Memo |
10 |
|
RESU_MSG |
|
25 |
PROG_0 |
Memo |
10 |
|
RESU_MSG |
|
26 |
PROG_1 |
Memo |
10 |
|
RESU_MSG |
|
27 |
PROG_2 |
Memo |
10 |
|
RESU_MSG |
|
28 |
PROG_3 |
Memo |
10 |
|
RESU_MSG |
|
29 |
THRD_7 |
Memo |
10 |
|
RESU_MSG |
|
30 |
THRD_PERCM |
Memo |
10 |
|
RESU_MSG |
|
31 |
NEWCERT |
Memo |
10 |
|
RESU_MSG |
|
32 |
F488 |
Memo |
10 |
|
RESU_MSG |
|
1 |
NAME |
Character |
40 |
|
CENTER80 |
|
2 |
MAIN_ADDR1 |
Character |
40 |
|
CENTER80 |
|
3 |
MAIN_ADDR2 |
Character |
40 |
|
CENTER80 |
|
4 |
MAIN_CITY |
Character |
26 |
|
CENTER80 |
|
5 |
MAIN_STATE |
Character |
2 |
|
CENTER80 |
|
6 |
MAIN_ZIP |
Character |
10 |
|
CENTER80 |
|
7 |
MAIN_PHONE |
Character |
12 |
|
CENTER80 |
|
8 |
IDAP |
Character |
1 |
|
CENTER80 |
|
9 |
D_PAS_IDAP |
Character |
10 |
|
CENTER80 |
|
10 |
CODE |
Character |
1 |
|
CENTER80 |
|
11 |
D_PAS_CODE |
Character |
10 |
|
CENTER80 |
|
12 |
PBSG |
Character |
1 |
|
CENTER80 |
|
13 |
D_PAS_PBSG |
Character |
10 |
|
CENTER80 |
|
14 |
SCEN |
Character |
1 |
|
CENTER80 |
|
15 |
D_PAS_SCEN |
Character |
10 |
|
CENTER80 |
|
16 |
THRD |
Character |
1 |
|
CENTER80 |
|
17 |
D_PAS_THRD |
Character |
10 |
|
CENTER80 |
|
18 |
PROG |
Character |
1 |
|
CENTER80 |
|
19 |
D_PAS_PROG |
Character |
10 |
|
CENTER80 |
|
1 |
CONTROL_NO |
Character |
6 |
|
PREVLEAD |
|
2 |
CERT_NO |
Character |
6 |
|
PREVLEAD |
|
3 |
NAME |
Character |
40 |
|
PREVLEAD |
|
4 |
MAIN_ADDR1 |
Character |
40 |
|
PREVLEAD |
|
5 |
MAIN_ADDR2 |
Character |
40 |
|
PREVLEAD |
|
6 |
MAIN_CITY |
Character |
26 |
|
PREVLEAD |
|
7 |
MAIN_STATE |
Character |
2 |
|
PREVLEAD |
|
8 |
MAIN_ZIP |
Character |
10 |
|
PREVLEAD |
|
9 |
DECEASED |
Logical |
1 |
|
PREVLEAD |
|
10 |
BAD_ADDR |
Logical |
1 |
|
PREVLEAD |
|
11 |
DEL_DUP |
Logical |
1 |
|
PREVLEAD |
|
1 |
FILE |
Character |
20 |
|
TMP |
|
1 |
CONF_APPL |
Memo |
10 |
|
LETTERS1 |
|
1 |
CONTROL_NO |
Character |
6 |
|
PROFIL |
|
2 |
D_ENTERED |
Date |
8 |
|
PROFIL |
|
3 |
D_MODIFIED |
Date |
8 |
|
PROFIL |
|
4 |
W_MODIFIED |
Character |
8 |
|
PROFIL |
|
1 |
NAME |
Character |
31 |
|
NY_ALFA |
|
2 |
CERT_NO |
Character |
6 |
|
NY_ALFA |
|
3 |
MAIN_ADDR1 |
Character |
39 |
|
NY_ALFA |
|
4 |
MAIN_ADDR2 |
Character |
36 |
|
NY_ALFA |
|
5 |
MAIN_CITY |
Character |
19 |
|
NY_ALFA |
|
6 |
MAIN_STATE |
Character |
2 |
|
NY_ALFA |
|
7 |
MAIN_ZIP |
Character |
10 |
|
NY_ALFA |
|
8 |
MAIN_PHONE |
Character |
12 |
|
NY_ALFA |
|
9 |
D_CERTIF |
Date |
8 |
|
NY_ALFA |
|
10 |
BAD_ADDR |
Character |
1 |
|
NY_ALFA |
|
1 |
CONTROL_NO |
Character |
6 |
|
RESULT |
|
2 |
REG_NO |
Character |
8 |
|
RESULT |
|
3 |
D_EXAM |
Date |
8 |
|
RESULT |
|
4 |
SECTION |
Character |
4 |
|
RESULT |
|
5 |
SCORE |
Numeric |
6 |
1 |
RESULT |
|
1 |
COURSE_NO |
Character |
5 |
|
IDCEC00 |
|
2 |
VERSION |
Character |
4 |
|
IDCEC00 |
|
3 |
SUBJECT |
Character |
8 |
|
IDCEC00 |
|
4 |
CREDITS |
Numeric |
4 |
1 |
IDCEC00 |
|
5 |
SPONSOR |
Character |
10 |
|
IDCEC00 |
|
6 |
TITLE |
Character |
65 |
|
IDCEC00 |
|
1 |
CONTROL_NO |
Character |
6 |
|
ADDRTEMP |
|
2 |
OLDCONTROL |
Character |
10 |
|
ADDRTEMP |
|
3 |
CERT_NO |
Character |
6 |
|
ADDRTEMP |
|
4 |
D_ENTERED |
Date |
8 |
|
ADDRTEMP |
|
5 |
W_ENTERED |
Character |
8 |
|
ADDRTEMP |
|
6 |
D_MODIFIED |
Date |
8 |
|
ADDRTEMP |
|
7 |
W_MODIFIED |
Character |
8 |
|
ADDRTEMP |
|
8 |
NAME |
Character |
40 |
|
ADDRTEMP |
|
9 |
MAIN_ADDR1 |
Character |
40 |
|
ADDRTEMP |
|
10 |
MAIN_ADDR2 |
Character |
40 |
|
ADDRTEMP |
|
11 |
MAIN_CITY |
Character |
26 |
|
ADDRTEMP |
|
12 |
MAIN_STATE |
Character |
2 |
|
ADDRTEMP |
|
13 |
MAIN_ZIP |
Character |
10 |
|
ADDRTEMP |
|
14 |
MAIN_PHONE |
Character |
10 |
|
ADDRTEMP |
|
15 |
MAIN_EXTN |
Character |
7 |
|
ADDRTEMP |
|
16 |
MAIN_FAX |
Character |
10 |
|
ADDRTEMP |
|
17 |
MAIN_TYPE |
Character |
1 |
|
ADDRTEMP |
|
18 |
EMAIL1 |
Character |
40 |
|
ADDRTEMP |
|
19 |
WORK_FIRM |
Character |
40 |
|
ADDRTEMP |
|
20 |
WORK_ADDR |
Character |
40 |
|
ADDRTEMP |
|
21 |
WORK_CITY |
Character |
26 |
|
ADDRTEMP |
|
22 |
WORK_STATE |
Character |
2 |
|
ADDRTEMP |
|
23 |
WORK_ZIP |
Character |
10 |
|
ADDRTEMP |
|
24 |
WORK_PHONE |
Character |
10 |
|
ADDRTEMP |
|
25 |
WORK_EXTN |
Character |
7 |
|
ADDRTEMP |
|
26 |
WORK_FAX |
Character |
10 |
|
ADDRTEMP |
|
27 |
WORK_TYPE |
Character |
1 |
|
ADDRTEMP |
|
28 |
EMAIL2 |
Character |
40 |
|
ADDRTEMP |
|
29 |
ON_HOLD |
Logical |
1 |
|
ADDRTEMP |
|
30 |
DECEASED |
Logical |
1 |
|
ADDRTEMP |
|
31 |
BAD_ADDR |
Logical |
1 |
|
ADDRTEMP |
|
32 |
BOUNCED |
Logical |
1 |
|
ADDRTEMP |
|
33 |
D_BNC |
Date |
8 |
|
ADDRTEMP |
|
34 |
D_BNC_CLR |
Date |
8 |
|
ADDRTEMP |
|
35 |
DEL_DUP |
Logical |
1 |
|
ADDRTEMP |
|
36 |
BALANCE |
Numeric |
8 |
2 |
ADDRTEMP |
|
37 |
INACTIVE |
Logical |
1 |
|
ADDRTEMP |
|
38 |
DOB |
Character |
6 |
|
ADDRTEMP |
|
39 |
SSN |
Character |
9 |
|
ADDRTEMP |
|
40 |
PREF_ADDR |
Character |
1 |
|
ADDRTEMP |
|
41 |
REC_TYPE |
Character |
1 |
|
ADDRTEMP |
|
42 |
OTHER |
Character |
10 |
|
ADDRTEMP |
|
43 |
LATE_FEE |
Logical |
1 |
|
ADDRTEMP |
|
44 |
D_LRF_PAID |
Date |
8 |
|
ADDRTEMP |
|
45 |
CREDIT |
Logical |
1 |
|
ADDRTEMP |
|
46 |
D_REJ |
Date |
8 |
|
ADDRTEMP |
|
47 |
D_REJ_CLR |
Date |
8 |
|
ADDRTEMP |
|
48 |
NOTE |
Memo |
10 |
|
ADDRTEMP |
|
49 |
CHANGED |
Logical |
1 |
|
ADDRTEMP |
|
50 |
ARCH |
Memo |
10 |
|
ADDRTEMP |
|
51 |
JUROR |
Character |
5 |
|
ADDRTEMP |
|
1 |
CERT_NO |
Character |
6 |
|
AZ2 |
|
2 |
NAME |
Character |
40 |
|
AZ2 |
|
3 |
MAIN_ADDR1 |
Character |
40 |
|
AZ2 |
|
4 |
MAIN_ADDR2 |
Character |
40 |
|
AZ2 |
|
5 |
MAIN_CITY |
Character |
26 |
|
AZ2 |
|
6 |
MAIN_STATE |
Character |
2 |
|
AZ2 |
|
7 |
MAIN_ZIP |
Character |
10 |
|
AZ2 |
|
8 |
MAIN_PHONE |
Character |
12 |
|
AZ2 |
|
9 |
MAIN_FAX |
Character |
12 |
|
AZ2 |
|
1 |
NAME |
Character |
50 |
|
RESI |
|
2 |
MAIN_ADDR1 |
Character |
50 |
|
RESI |
|
3 |
MAIN_ADDR2 |
Character |
50 |
|
RESI |
|
4 |
MAIN_CITY |
Character |
50 |
|
RESI |
|
5 |
MAIN_STATE |
Character |
50 |
|
RESI |
|
6 |
MAIN_ZIP |
Character |
50 |
|
RESI |
|
1 |
NAME |
Character |
40 |
Asc |
TEMP |
|
2 |
DATE_COURS |
Date |
8 |
|
TEMP |
|
3 |
COURSE_NO |
Character |
9 |
|
TEMP |
|
4 |
LOC_CITY |
Character |
15 |
|
TEMP |
|
5 |
LOC_ST |
Character |
2 |
|
TEMP |
|
6 |
MAIN_ADDR1 |
Character |
40 |
|
TEMP |
|
7 |
MAIN_ADDR2 |
Character |
40 |
|
TEMP |
|
8 |
CITY |
Character |
20 |
|
TEMP |
|
9 |
STATE |
Character |
2 |
|
TEMP |
|
10 |
ZIP |
Character |
10 |
|
TEMP |
|
11 |
POSTAL |
Character |
7 |
|
TEMP |
|
12 |
PHONE |
Character |
10 |
|
TEMP |
|
13 |
CAN_NO |
Character |
10 |
|
TEMP |
|
14 |
ENTRY |
Character |
4 |
|
TEMP |
|
15 |
AFF |
Character |
42 |
|
TEMP |
|
16 |
AFF_OTHR |
Character |
7 |
|
TEMP |
|
17 |
EMP_NAME |
Character |
40 |
|
TEMP |
|
18 |
EMP_ADDR |
Character |
40 |
|
TEMP |
|
19 |
EMP_CITY |
Character |
20 |
|
TEMP |
|
20 |
EMP_ST |
Character |
2 |
|
TEMP |
|
21 |
EMP_ZIP |
Character |
10 |
|
TEMP |
|
22 |
EMP_POSTAL |
Character |
7 |
|
TEMP |
|
23 |
RATE |
Numeric |
1 |
|
TEMP |
|
24 |
IN_DBF |
Logical |
1 |
|
TEMP |
|
25 |
CERTIF |
Logical |
1 |
|
TEMP |
|
26 |
PROCESSED |
Date |
8 |
|
TEMP |
|
27 |
ASID |
Logical |
1 |
|
TEMP |
|
28 |
IDC |
Logical |
1 |
|
TEMP |
|
29 |
IDEC |
Logical |
1 |
|
TEMP |
|
30 |
IIDA |
Logical |
1 |
|
TEMP |
|
31 |
QUART |
Date |
8 |
|
TEMP |
|
1 |
NAME |
Character |
40 |
|
WITH |
|
2 |
DATE_COURS |
Date |
8 |
|
WITH |
|
3 |
COURSE_NO |
Character |
8 |
|
WITH |
|
4 |
LOC_CITY |
Character |
15 |
|
WITH |
|
5 |
LOC_ST |
Character |
2 |
|
WITH |
|
6 |
MAIN_ADDR1 |
Character |
40 |
|
WITH |
|
7 |
MAIN_ADDR2 |
Character |
40 |
|
WITH |
|
8 |
CITY |
Character |
20 |
|
WITH |
|
9 |
STATE |
Character |
2 |
|
WITH |
|
10 |
ZIP |
Character |
10 |
|
WITH |
|
11 |
POSTAL |
Character |
7 |
|
WITH |
|
12 |
PHONE |
Character |
10 |
|
WITH |
|
13 |
CAN_NO |
Character |
10 |
|
WITH |
|
14 |
ENTRY |
Character |
4 |
|
WITH |
|
15 |
AFF |
Character |
42 |
|
WITH |
|
16 |
AFF_OTHR |
Character |
7 |
|
WITH |
|
17 |
EMP_NAME |
Character |
40 |
|
WITH |
|
18 |
EMP_ADDR |
Character |
40 |
|
WITH |
|
19 |
EMP_CITY |
Character |
20 |
|
WITH |
|
20 |
EMP_ST |
Character |
2 |
|
WITH |
|
21 |
EMP_ZIP |
Character |
10 |
|
WITH |
|
22 |
EMP_POSTAL |
Character |
7 |
|
WITH |
|
23 |
RATE |
Numeric |
1 |
|
WITH |
|
24 |
IN_DBF |
Logical |
1 |
|
WITH |
|
25 |
CERTIF |
Logical |
1 |
|
WITH |
|
26 |
PROCESSED |
Date |
8 |
|
WITH |
|
27 |
ASID |
Logical |
1 |
|
WITH |
|
28 |
IDC |
Logical |
1 |
|
WITH |
|
29 |
IDEC |
Logical |
1 |
|
WITH |
|
30 |
IIDA |
Logical |
1 |
|
WITH |
|
1 |
CERT |
Memo |
10 |
|
RESU_MS1 |
|
2 |
REVIEW_1 |
Memo |
10 |
|
RESU_MS1 |
|
3 |
GENERAL |
Memo |
10 |
|
RESU_MS1 |
|
4 |
REVIEW |
Memo |
10 |
|
RESU_MS1 |
|
1 |
CONTROL_NO |
Character |
6 |
|
TEMPA |
|
2 |
NAME |
Character |
40 |
|
TEMPA |
|
3 |
BAL_OWE |
Logical |
1 |
|
TEMPA |
|
4 |
DATE_COURS |
Date |
8 |
|
TEMPA |
|
5 |
COURSE_NO |
Character |
9 |
|
TEMPA |
|
6 |
D_RECEIVED |
Date |
8 |
|
TEMPA |
|
7 |
D_ENTERED |
Date |
8 |
|
TEMPA |
|
8 |
LOC_CITY |
Character |
15 |
|
TEMPA |
|
9 |
LOC_ST |
Character |
2 |
|
TEMPA |
|
10 |
MAIN_ADDR1 |
Character |
40 |
|
TEMPA |
|
11 |
MAIN_ADDR2 |
Character |
40 |
|
TEMPA |
|
12 |
CITY |
Character |
20 |
|
TEMPA |
|
13 |
STATE |
Character |
2 |
|
TEMPA |
|
14 |
ZIP |
Character |
10 |
|
TEMPA |
|
15 |
POSTAL |
Character |
7 |
|
TEMPA |
|
16 |
PHONE |
Character |
10 |
|
TEMPA |
|
17 |
CAN_NO |
Character |
10 |
|
TEMPA |
|
18 |
ENTRY |
Character |
4 |
|
TEMPA |
|
19 |
AFF |
Character |
42 |
|
TEMPA |
|
20 |
AFF_OTHR |
Character |
7 |
|
TEMPA |
|
21 |
EMP_NAME |
Character |
40 |
|
TEMPA |
|
22 |
EMP_ADDR |
Character |
40 |
|
TEMPA |
|
23 |
EMP_CITY |
Character |
20 |
|
TEMPA |
|
24 |
EMP_ST |
Character |
2 |
|
TEMPA |
|
25 |
EMP_ZIP |
Character |
10 |
|
TEMPA |
|
26 |
EMP_POSTAL |
Character |
7 |
|
TEMPA |
|
27 |
RATE |
Numeric |
1 |
|
TEMPA |
|
28 |
IN_DBF |
Logical |
1 |
|
TEMPA |
|
29 |
CERTIF |
Logical |
1 |
|
TEMPA |
|
30 |
PROCESSED |
Date |
8 |
|
TEMPA |
|
31 |
ASID |
Logical |
1 |
|
TEMPA |
|
32 |
IDC |
Logical |
1 |
|
TEMPA |
|
33 |
IDEC |
Logical |
1 |
|
TEMPA |
|
34 |
IIDA |
Logical |
1 |
|
TEMPA |
|
35 |
QUART |
Date |
8 |
|
TEMPA |
|
36 |
D |
Character |
1 |
|
TEMPA |
|
1 |
NAME |
Character |
40 |
|
RM0499 |
|
2 |
MAIN_ADDR1 |
Character |
40 |
|
RM0499 |
|
3 |
MAIN_ADDR2 |
Character |
40 |
|
RM0499 |
|
4 |
MAIN_CITY |
Character |
26 |
|
RM0499 |
|
5 |
MAIN_STATE |
Character |
2 |
|
RM0499 |
|
6 |
MAIN_ZIP |
Character |
10 |
|
RM0499 |
|
7 |
COUNTRY |
Character |
6 |
|
RM0499 |
|
1 |
CONTROL_NO |
Character |
6 |
Asc |
SCO_0496 |
|
2 |
OLDCONTROL |
Character |
10 |
|
SCO_0496 |
|
3 |
PBSG |
Numeric |
7 |
1 |
SCO_0496 |
|
4 |
IDAP |
Numeric |
7 |
1 |
SCO_0496 |
|
5 |
CODE |
Numeric |
7 |
1 |
SCO_0496 |
|
6 |
CODE_OLD |
Numeric |
7 |
1 |
SCO_0496 |
|
7 |
THRD |
Numeric |
7 |
1 |
SCO_0496 |
|
8 |
PROG |
Numeric |
7 |
1 |
SCO_0496 |
|
9 |
SCEN |
Numeric |
7 |
1 |
SCO_0496 |
|
10 |
SCAN_NAME |
Character |
30 |
Asc |
SCO_0496 |
|
11 |
COMMENTS |
Character |
120 |
|
SCO_0496 |
|
1 |
SECT |
Character |
4 |
|
SCA_0496 |
|
2 |
CONTROL_NO |
Character |
6 |
|
SCA_0496 |
|
3 |
SUFFIX |
Character |
4 |
|
SCA_0496 |
|
4 |
CENTER |
Numeric |
3 |
|
SCA_0496 |
|
5 |
SCORE |
Numeric |
7 |
1 |
SCA_0496 |
|
6 |
PASSED |
Logical |
1 |
|
SCA_0496 |
|
7 |
W_CHECKIN |
Character |
8 |
|
SCA_0496 |
|
8 |
D_CHECKIN |
Date |
8 |
|
SCA_0496 |
|
9 |
W_SCANNED |
Character |
8 |
|
SCA_0496 |
|
10 |
D_SCANNED |
Date |
8 |
|
SCA_0496 |
|
11 |
W_SCORED |
Character |
8 |
|
SCA_0496 |
|
12 |
D_SCORED |
Date |
8 |
|
SCA_0496 |
|
13 |
SCAN_NAME |
Character |
30 |
|
SCA_0496 |
|
14 |
RESPONSES |
Character |
130 |
|
SCA_0496 |
|
15 |
JUROR |
Character |
5 |
|
SCA_0496 |
|
16 |
U_QTR |
Logical |
1 |
|
SCA_0496 |
|
17 |
L_QTR |
Logical |
1 |
|
SCA_0496 |
|
1 |
CONTROL_NO |
Character |
6 |
|
BADRESU |
|
2 |
REASON |
Character |
30 |
|
BADRESU |
|
1 |
NEXT_CONT |
Numeric |
6 |
|
NCI_SYS |
|
2 |
NEXT_CERT |
Numeric |
6 |
|
NCI_SYS |
|
3 |
NEXT_ORD |
Numeric |
6 |
|
NCI_SYS |
|
4 |
NEXT_TRAN |
Numeric |
6 |
|
NCI_SYS |
|
5 |
NEXT_ELIG |
Date |
8 |
|
NCI_SYS |
|
6 |
CURR_EXAM |
Character |
6 |
|
NCI_SYS |
|
1 |
NAME |
Character |
40 |
Asc |
ASID |
|
2 |
DATE_COURS |
Date |
8 |
|
ASID |
|
3 |
COURSE_NO |
Character |
8 |
|
ASID |
|
4 |
LOC_CITY |
Character |
15 |
|
ASID |
|
5 |
LOC_ST |
Character |
2 |
|
ASID |
|
6 |
MAIN_ADDR1 |
Character |
40 |
|
ASID |
|
7 |
MAIN_ADDR2 |
Character |
40 |
|
ASID |
|
8 |
CITY |
Character |
20 |
|
ASID |
|
9 |
STATE |
Character |
2 |
|
ASID |
|
10 |
ZIP |
Character |
10 |
|
ASID |
|
11 |
POSTAL |
Character |
7 |
|
ASID |
|
12 |
PHONE |
Character |
10 |
|
ASID |
|
13 |
CAN_NO |
Character |
10 |
|
ASID |
|
14 |
ENTRY |
Character |
4 |
|
ASID |
|
15 |
AFF |
Character |
42 |
|
ASID |
|
16 |
AFF_OTHR |
Character |
7 |
|
ASID |
|
17 |
EMP_NAME |
Character |
40 |
|
ASID |
|
18 |
EMP_ADDR |
Character |
40 |
|
ASID |
|
19 |
EMP_CITY |
Character |
20 |
|
ASID |
|
20 |
EMP_ST |
Character |
2 |
|
ASID |
|
21 |
EMP_ZIP |
Character |
10 |
|
ASID |
|
22 |
EMP_POSTAL |
Character |
7 |
|
ASID |
|
23 |
RATE |
Numeric |
1 |
|
ASID |
|
24 |
IN_DBF |
Logical |
1 |
|
ASID |
|
25 |
CERTIF |
Logical |
1 |
|
ASID |
|
26 |
PROCESSED |
Date |
8 |
|
ASID |
|
27 |
ASID |
Logical |
1 |
|
ASID |
|
28 |
IDC |
Logical |
1 |
|
ASID |
|
29 |
IDEC |
Logical |
1 |
|
ASID |
|
30 |
IIDA |
Logical |
1 |
|
ASID |
|
1 |
NAME |
Character |
40 |
|
NY_DATE |
|
2 |
CERT_NO |
Character |
6 |
|
NY_DATE |
|
3 |
MAIN_ADDR1 |
Character |
40 |
|
NY_DATE |
|
4 |
MAIN_ADDR2 |
Character |
40 |
|
NY_DATE |
|
5 |
MAIN_CITY |
Character |
26 |
|
NY_DATE |
|
6 |
MAIN_STATE |
Character |
2 |
|
NY_DATE |
|
7 |
MAIN_ZIP |
Character |
10 |
|
NY_DATE |
|
8 |
MAIN_PHONE |
Character |
10 |
|
NY_DATE |
|
9 |
D_CERTIF |
Date |
8 |
|
NY_DATE |
|
10 |
BAD_ADDR |
Logical |
1 |
|
NY_DATE |
|
1 |
CONTROL_NO |
Character |
6 |
Asc |
SCO_1096 |
|
2 |
OLDCONTROL |
Character |
10 |
|
SCO_1096 |
|
3 |
PBSG |
Numeric |
7 |
1 |
SCO_1096 |
|
4 |
IDAP |
Numeric |
7 |
1 |
SCO_1096 |
|
5 |
CODE |
Numeric |
7 |
1 |
SCO_1096 |
|
6 |
CODE_OLD |
Numeric |
7 |
1 |
SCO_1096 |
|
7 |
THRD |
Numeric |
7 |
1 |
SCO_1096 |
|
8 |
PROG |
Numeric |
7 |
1 |
SCO_1096 |
|
9 |
SCEN |
Numeric |
7 |
1 |
SCO_1096 |
|
10 |
SCAN_NAME |
Character |
30 |
|
SCO_1096 |
|
11 |
COMMENTS |
Character |
120 |
|
SCO_1096 |
|
1 |
NAME |
Character |
50 |
|
RESI2 |
|
2 |
MAIN_ADDR1 |
Character |
50 |
|
RESI2 |
|
3 |
MAIN_ADDR2 |
Character |
50 |
|
RESI2 |
|
4 |
MAIN_CITY |
Character |
50 |
|
RESI2 |
|
5 |
MAIN_STATE |
Character |
50 |
|
RESI2 |
|
6 |
MAIN_ZIP |
Character |
50 |
|
RESI2 |
|
1 |
CONTROL_NO |
Character |
6 |
|
JURY2 |
|
2 |
CENTER |
Character |
3 |
|
JURY2 |
|
3 |
D_EXAM |
Character |
6 |
|
JURY2 |
|
4 |
TYPE |
Character |
1 |
|
JURY2 |
|
5 |
DAYS |
Character |
8 |
|
JURY2 |
|
1 |
LAST_NAME |
Character |
18 |
|
NEVA_APR2002 |
|
2 |
FIRST_NAME |
Character |
12 |
|
NEVA_APR2002 |
|
3 |
MI |
Character |
1 |
|
NEVA_APR2002 |
|
4 |
CONTROL_NO |
Character |
9 |
|
NEVA_APR2002 |
|
5 |
TEST_SITE |
Character |
4 |
|
NEVA_APR2002 |
|
6 |
ITEMS |
Character |
30 |
|
NEVA_APR2002 |
|
1 |
CONTROL_NO |
Character |
6 |
Asc |
SCO_1095 |
|
2 |
OLDCONTROL |
Character |
10 |
|
SCO_1095 |
|
3 |
PBSG |
Numeric |
7 |
1 |
SCO_1095 |
|
4 |
IDAP |
Numeric |
7 |
1 |
SCO_1095 |
|
5 |
CODE |
Numeric |
7 |
1 |
SCO_1095 |
|
6 |
CODE_OLD |
Numeric |
7 |
1 |
SCO_1095 |
|
7 |
THRD |
Numeric |
7 |
1 |
SCO_1095 |
|
8 |
PROG |
Numeric |
7 |
1 |
SCO_1095 |
|
9 |
SCEN |
Numeric |
7 |
1 |
SCO_1095 |
|
10 |
SCAN_NAME |
Character |
30 |
|
SCO_1095 |
|
11 |
COMMENTS |
Character |
120 |
|
SCO_1095 |
|
1 |
SECT |
Character |
4 |
|
SCA_0495 |
|
2 |
CONTROL_NO |
Character |
6 |
|
SCA_0495 |
|
3 |
SUFFIX |
Character |
4 |
|
SCA_0495 |
|
4 |
CENTER |
Numeric |
3 |
|
SCA_0495 |
|
5 |
SCORE |
Numeric |
7 |
1 |
SCA_0495 |
|
6 |
PASSED |
Logical |
1 |
|
SCA_0495 |
|
7 |
W_CHECKIN |
Character |
8 |
|
SCA_0495 |
|
8 |
D_CHECKIN |
Date |
8 |
|
SCA_0495 |
|
9 |
W_SCANNED |
Character |
8 |
|
SCA_0495 |
|
10 |
D_SCANNED |
Date |
8 |
|
SCA_0495 |
|
11 |
W_SCORED |
Character |
8 |
|
SCA_0495 |
|
12 |
D_SCORED |
Date |
8 |
|
SCA_0495 |
|
13 |
SCAN_NAME |
Character |
30 |
|
SCA_0495 |
|
14 |
RESPONSES |
Character |
130 |
|
SCA_0495 |
|
15 |
JUROR |
Character |
5 |
|
SCA_0495 |
|
16 |
U_QTR |
Logical |
1 |
|
SCA_0495 |
|
17 |
L_QTR |
Logical |
1 |
|
SCA_0495 |
|
1 |
CONTROL_NO |
Character |
6 |
|
ORDERS |
|
2 |
ORDER_NO |
Character |
6 |
Asc |
ORDERS |
|
3 |
D_ENTERED |
Date |
8 |
|
ORDERS |
|
4 |
W_ENTERED |
Character |
8 |
|
ORDERS |
|
5 |
D_MODIFIED |
Date |
8 |
|
ORDERS |
|
6 |
W_MODIFIED |
Character |
8 |
|
ORDERS |
|
7 |
D_SHIPPED |
Date |
8 |
|
ORDERS |
|
8 |
Q_APPL |
Numeric |
3 |
|
ORDERS |
|
9 |
Q_INFO |
Numeric |
3 |
|
ORDERS |
|
10 |
Q_GDUPD |
Numeric |
3 |
|
ORDERS |
|
11 |
Q_STGD |
Numeric |
3 |
|
ORDERS |
|
12 |
A_STGD |
Numeric |
3 |
|
ORDERS |
|
13 |
Q_JOBANAL |
Numeric |
3 |
|
ORDERS |
|
14 |
A_JOBANAL |
Numeric |
3 |
|
ORDERS |
|
15 |
Q_VID1 |
Numeric |
3 |
|
ORDERS |
|
16 |
A_VID1 |
Numeric |
3 |
|
ORDERS |
|
17 |
Q_VID2 |
Numeric |
3 |
|
ORDERS |
|
18 |
A_VID2 |
Numeric |
3 |
|
ORDERS |
|
19 |
SHP_OVRD |
Logical |
1 |
|
ORDERS |
|
20 |
NEXTDAY |
Logical |
1 |
|
ORDERS |
|
21 |
ORD_SHIP |
Numeric |
8 |
2 |
ORDERS |
|
22 |
ORD_AMNT |
Numeric |
8 |
2 |
ORDERS |
|
23 |
CHECK_NO |
Character |
6 |
|
ORDERS |
|
24 |
SHIP_NAME |
Character |
40 |
|
ORDERS |
|
25 |
SHIP_ADDR1 |
Character |
40 |
|
ORDERS |
|
26 |
SHIP_ADDR2 |
Character |
40 |
|
ORDERS |
|
27 |
SHIP_CITY |
Character |
22 |
|
ORDERS |
|
28 |
SHIP_STATE |
Character |
2 |
|
ORDERS |
|
29 |
SHIP_ZIP |
Character |
10 |
|
ORDERS |
|
30 |
TRAN_NO |
Character |
6 |
|
ORDERS |
|
31 |
ORD_INFO |
Memo |
10 |
|
ORDERS |
|
1 |
SECT |
Character |
4 |
|
SCA_0194 |
|
2 |
CONTROL_NO |
Character |
6 |
|
SCA_0194 |
|
3 |
SUFFIX |
Character |
4 |
|
SCA_0194 |
|
4 |
CENTER |
Numeric |
3 |
|
SCA_0194 |
|
5 |
SCORE |
Numeric |
7 |
1 |
SCA_0194 |
|
6 |
PASSED |
Logical |
1 |
|
SCA_0194 |
|
7 |
W_CHECKIN |
Character |
8 |
|
SCA_0194 |
|
8 |
D_CHECKIN |
Date |
8 |
|
SCA_0194 |
|
9 |
W_SCANNED |
Character |
8 |
|
SCA_0194 |
|
10 |
D_SCANNED |
Date |
8 |
|
SCA_0194 |
|
11 |
W_SCORED |
Character |
8 |
|
SCA_0194 |
|
12 |
D_SCORED |
Date |
8 |
|
SCA_0194 |
|
13 |
SCAN_NAME |
Character |
30 |
|
SCA_0194 |
|
14 |
RESPONSES |
Character |
130 |
|
SCA_0194 |
|
15 |
JUROR |
Character |
5 |
|
SCA_0194 |
|
16 |
U_QTR |
Logical |
1 |
|
SCA_0194 |
|
17 |
L_QTR |
Logical |
1 |
|
SCA_0194 |
|
1 |
SD |
Memo |
10 |
|
SURVEY1E |
|
1 |
NAME |
Character |
28 |
Asc |
CANMOVE |
|
2 |
MAIN_ADDR1 |
Character |
38 |
|
CANMOVE |
|
3 |
MAIN_ADDR2 |
Character |
41 |
|
CANMOVE |
|
4 |
MAIN_CITY |
Character |
20 |
|
CANMOVE |
|
5 |
MAIN_STATE |
Character |
3 |
|
CANMOVE |
|
6 |
MAIN_ZIP |
Character |
8 |
|
CANMOVE |
|
1 |
COURSE_NO |
Character |
8 |
|
CECBACK |
|
2 |
VERSION |
Character |
4 |
|
CECBACK |
|
3 |
TITLE |
Character |
65 |
|
CECBACK |
|
4 |
SUBJECT |
Character |
8 |
|
CECBACK |
|
5 |
CREDITS |
Numeric |
3 |
1 |
CECBACK |
|
6 |
SPONSOR |
Character |
10 |
|
CECBACK |
|
7 |
DATE_OFFER |
Character |
17 |
|
CECBACK |
|
8 |
NUMBER_ATT |
Numeric |
5 |
|
CECBACK |
|
9 |
NUMBER_SUB |
Numeric |
5 |
|
CECBACK |
|
10 |
INSTRUCTS |
Character |
20 |
|
CECBACK |
|
11 |
IDCEC |
Logical |
1 |
|
CECBACK |
|
12 |
RATING |
Numeric |
3 |
|
CECBACK |
|
1 |
CERT_NO |
Character |
6 |
|
CERT_NEW |
|
2 |
CONTROL_NO |
Character |
6 |
|
CERT_NEW |
|
3 |
OLDCONTROL |
Character |
10 |
|
CERT_NEW |
|
4 |
D_ENTERED |
Date |
8 |
|
CERT_NEW |
|
5 |
D_RENEWED |
Date |
8 |
|
CERT_NEW |
|
6 |
W_RENEWED |
Character |
8 |
|
CERT_NEW |
|
7 |
D_MODIFIED |
Date |
8 |
|
CERT_NEW |
|
8 |
W_MODIFIED |
Character |
8 |
|
CERT_NEW |
|
9 |
LICENSED |
Logical |
1 |
|
CERT_NEW |
|
10 |
LIC_NO1 |
Character |
6 |
|
CERT_NEW |
|
11 |
LIC_NO2 |
Character |
6 |
|
CERT_NEW |
|
12 |
LIC_NO3 |
Character |
6 |
|
CERT_NEW |
|
13 |
LIC_STATE1 |
Character |
2 |
|
CERT_NEW |
|
14 |
LIC_STATE2 |
Character |
2 |
|
CERT_NEW |
|
15 |
LIC_STATE3 |
Character |
2 |
|
CERT_NEW |
|
16 |
LAPSED |
Logical |
1 |
|
CERT_NEW |
|
17 |
DENIED |
Logical |
1 |
|
CERT_NEW |
|
18 |
VIOLATED |
Logical |
1 |
|
CERT_NEW |
|
19 |
PRINCIPAL |
Logical |
1 |
|
CERT_NEW |
|
20 |
FIRM_NAME |
Character |
40 |
|
CERT_NEW |
|
21 |
FIRM_ADDR |
Character |
40 |
|
CERT_NEW |
|
22 |
FIRM_CITY |
Character |
26 |
|
CERT_NEW |
|
23 |
FIRM_STATE |
Character |
2 |
|
CERT_NEW |
|
24 |
FIRM_ZIP |
Character |
10 |
|
CERT_NEW |
|
25 |
FIRM_PHONE |
Character |
10 |
|
CERT_NEW |
|
26 |
FIRM_HIRED |
Date |
8 |
|
CERT_NEW |
|
27 |
POSITION |
Character |
1 |
|
CERT_NEW |
|
28 |
FULLTIME |
Logical |
1 |
|
CERT_NEW |
|
29 |
EDUCATOR |
Logical |
1 |
|
CERT_NEW |
|
30 |
SCHOOLCODE |
Character |
3 |
|
CERT_NEW |
|
31 |
INST_HIRED |
Date |
8 |
|
CERT_NEW |
|
32 |
EMPLOYED |
Logical |
1 |
|
CERT_NEW |
|
33 |
CHECK_NO |
Character |
6 |
|
CERT_NEW |
|
34 |
CHECK_AMT |
Numeric |
5 |
|
CERT_NEW |
|
1 |
SECT |
Character |
4 |
|
CODE0197 |
|
2 |
AREA |
Character |
4 |
|
CODE0197 |
|
3 |
POINTS |
Numeric |
3 |
1 |
CODE0197 |
|
4 |
QUES |
Numeric |
5 |
|
CODE0197 |
|
5 |
PICKED |
Logical |
1 |
|
CODE0197 |
|
6 |
SEQ |
Numeric |
3 |
|
CODE0197 |
|
7 |
D_LASTUSED |
Date |
8 |
|
CODE0197 |
|
1 |
SECT |
Character |
4 |
|
CODE0400 |
|
2 |
AREA |
Character |
4 |
|
CODE0400 |
|
3 |
POINTS |
Numeric |
3 |
1 |
CODE0400 |
|
4 |
QUES |
Numeric |
5 |
|
CODE0400 |
|
5 |
PICKED |
Logical |
1 |
|
CODE0400 |
|
6 |
SEQ |
Numeric |
3 |
|
CODE0400 |
|
7 |
D_LASTUSED |
Date |
8 |
|
CODE0400 |
|
1 |
SECT |
Character |
4 |
|
CODE0494 |
|
2 |
AREA |
Character |
4 |
|
CODE0494 |
|
3 |
POINTS |
Numeric |
3 |
1 |
CODE0494 |
|
4 |
QUES |
Numeric |
5 |
|
CODE0494 |
|
5 |
PICKED |
Logical |
1 |
|
CODE0494 |
|
6 |
SEQ |
Numeric |
3 |
|
CODE0494 |
|
7 |
D_LASTUSED |
Date |
8 |
|
CODE0494 |
|
1 |
CONTROL_NO |
Character |
6 |
|
Z$SCO |
|
2 |
OLDCONTROL |
Character |
10 |
|
Z$SCO |
|
3 |
PBSG |
Numeric |
7 |
1 |
Z$SCO |
|
4 |
IDAP |
Numeric |
7 |
1 |
Z$SCO |
|
5 |
CODE |
Numeric |
7 |
1 |
Z$SCO |
|
6 |
CODE_OLD |
Numeric |
7 |
1 |
Z$SCO |
|
7 |
THRD |
Numeric |
7 |
1 |
Z$SCO |
|
8 |
PROG |
Numeric |
7 |
1 |
Z$SCO |
|
9 |
SCEN |
Numeric |
7 |
1 |
Z$SCO |
|
10 |
SCAN_NAME |
Character |
30 |
|
Z$SCO |
|
11 |
COMMENTS |
Character |
120 |
|
Z$SCO |
|
1 |
SECT |
Character |
4 |
|
CODE0496 |
|
2 |
AREA |
Character |
4 |
|
CODE0496 |
|
3 |
POINTS |
Numeric |
3 |
1 |
CODE0496 |
|
4 |
QUES |
Numeric |
5 |
|
CODE0496 |
|
5 |
PICKED |
Logical |
1 |
|
CODE0496 |
|
6 |
SEQ |
Numeric |
3 |
|
CODE0496 |
|
7 |
D_LASTUSED |
Date |
8 |
|
CODE0496 |
|
1 |
SECT |
Character |
4 |
|
CODE0497 |
|
2 |
AREA |
Character |
4 |
|
CODE0497 |
|
3 |
POINTS |
Numeric |
3 |
1 |
CODE0497 |
|
4 |
QUES |
Numeric |
5 |
|
CODE0497 |
|
5 |
PICKED |
Logical |
1 |
|
CODE0497 |
|
6 |
SEQ |
Numeric |
3 |
|
CODE0497 |
|
7 |
D_LASTUSED |
Date |
8 |
|
CODE0497 |
|
1 |
SECT |
Character |
4 |
|
CODE1000 |
|
2 |
AREA |
Character |
4 |
|
CODE1000 |
|
3 |
POINTS |
Numeric |
3 |
1 |
CODE1000 |
|
4 |
QUES |
Numeric |
5 |
|
CODE1000 |
|
5 |
PICKED |
Logical |
1 |
|
CODE1000 |
|
6 |
SEQ |
Numeric |
3 |
|
CODE1000 |
|
7 |
D_LASTUSED |
Date |
8 |
|
CODE1000 |
|
1 |
SECT |
Character |
4 |
|
CODE1096 |
|
2 |
AREA |
Character |
4 |
|
CODE1096 |
|
3 |
POINTS |
Numeric |
3 |
1 |
CODE1096 |
|
4 |
QUES |
Numeric |
5 |
|
CODE1096 |
|
5 |
PICKED |
Logical |
1 |
|
CODE1096 |
|
6 |
SEQ |
Numeric |
3 |
|
CODE1096 |
|
7 |
D_LASTUSED |
Date |
8 |
|
CODE1096 |
|
1 |
SECT |
Character |
4 |
|
CODE1097 |
|
2 |
AREA |
Character |
4 |
|
CODE1097 |
|
3 |
POINTS |
Numeric |
3 |
1 |
CODE1097 |
|
4 |
QUES |
Numeric |
5 |
|
CODE1097 |
|
5 |
PICKED |
Logical |
1 |
|
CODE1097 |
|
6 |
SEQ |
Numeric |
3 |
|
CODE1097 |
|
7 |
D_LASTUSED |
Date |
8 |
|
CODE1097 |
|
1 |
SECT |
Character |
4 |
|
CODE1099 |
|
2 |
AREA |
Character |
4 |
|
CODE1099 |
|
3 |
POINTS |
Numeric |
3 |
1 |
CODE1099 |
|
4 |
QUES |
Numeric |
5 |
|
CODE1099 |
|
5 |
PICKED |
Logical |
1 |
|
CODE1099 |
|
6 |
SEQ |
Numeric |
3 |
|
CODE1099 |
|
7 |
D_LASTUSED |
Date |
8 |
|
CODE1099 |
|
1 |
D_EXAM |
Character |
6 |
|
COUNT |
|
2 |
CENTER_NO |
Character |
3 |
|
COUNT |
|
3 |
SCEN |
Character |
1 |
|
COUNT |
|
4 |
PROJECT |
Character |
1 |
|
COUNT |
|
5 |
SCALE |
Character |
1 |
|
COUNT |
|
1 |
DATE1 |
Date |
8 |
|
DATER |
|
1 |
ORG_CODE |
Character |
2 |
Asc |
MEMB_ORG |
|
2 |
ORG_INIT |
Character |
20 |
|
MEMB_ORG |
|
3 |
ORG_NAME |
Character |
50 |
|
MEMB_ORG |
|
4 |
ORG_DIR |
Character |
40 |
|
MEMB_ORG |
|
5 |
ORG_ADDR |
Character |
40 |
|
MEMB_ORG |
|
6 |
ORG_CITY |
Character |
24 |
|
MEMB_ORG |
|
7 |
ORG_STATE |
Character |
2 |
|
MEMB_ORG |
|
8 |
ORG_ZIP |
Character |
9 |
|
MEMB_ORG |
|
9 |
ORG_PHONE |
Character |
10 |
|
MEMB_ORG |
|
10 |
ORG_FAX |
Character |
10 |
|
MEMB_ORG |
|
11 |
ORG_HOME |
Character |
10 |
|
MEMB_ORG |
|
1 |
CONTROL_NO |
Character |
6 |
|
CHK_1093 |
|
2 |
SECT |
Character |
4 |
|
CHK_1093 |
|
3 |
CENTER |
Numeric |
3 |
|
CHK_1093 |
|
4 |
USER |
Character |
8 |
|
CHK_1093 |
|
5 |
DATE |
Date |
8 |
|
CHK_1093 |
|
1 |
FIELD1 |
Character |
10 |
|
DUMMY |
|
1 |
CONTROL_NO |
Character |
6 |
Asc |
SCO_0494 |
|
2 |
OLDCONTROL |
Character |
10 |
|
SCO_0494 |
|
3 |
PBSG |
Numeric |
7 |
1 |
SCO_0494 |
|
4 |
IDAP |
Numeric |
7 |
1 |
SCO_0494 |
|
5 |
CODE |
Numeric |
7 |
1 |
SCO_0494 |
|
6 |
CODE_OLD |
Numeric |
7 |
1 |
SCO_0494 |
|
7 |
THRD |
Numeric |
7 |
1 |
SCO_0494 |
|
8 |
PROG |
Numeric |
7 |
1 |
SCO_0494 |
|
9 |
SCEN |
Numeric |
7 |
1 |
SCO_0494 |
|
10 |
SCAN_NAME |
Character |
30 |
|
SCO_0494 |
|
11 |
COMMENTS |
Character |
120 |
|
SCO_0494 |
|
1 |
SECT |
Character |
4 |
|
SCA_0494 |
|
2 |
CONTROL_NO |
Character |
6 |
|
SCA_0494 |
|
3 |
SUFFIX |
Character |
4 |
|
SCA_0494 |
|
4 |
CENTER |
Numeric |
3 |
|
SCA_0494 |
|
5 |
SCORE |
Numeric |
7 |
1 |
SCA_0494 |
|
6 |
PASSED |
Logical |
1 |
|
SCA_0494 |
|
7 |
W_CHECKIN |
Character |
8 |
|
SCA_0494 |
|
8 |
D_CHECKIN |
Date |
8 |
|
SCA_0494 |
|
9 |
W_SCANNED |
Character |
8 |
|
SCA_0494 |
|
10 |
D_SCANNED |
Date |
8 |
|
SCA_0494 |
|
11 |
W_SCORED |
Character |
8 |
|
SCA_0494 |
|
12 |
D_SCORED |
Date |
8 |
|
SCA_0494 |
|
13 |
SCAN_NAME |
Character |
30 |
|
SCA_0494 |
|
14 |
RESPONSES |
Character |
130 |
|
SCA_0494 |
|
15 |
JUROR |
Character |
5 |
|
SCA_0494 |
|
16 |
U_QTR |
Logical |
1 |
|
SCA_0494 |
|
17 |
L_QTR |
Logical |
1 |
|
SCA_0494 |
|
1 |
CONTROL_NO |
Character |
6 |
Asc |
SCO_0495 |
|
2 |
OLDCONTROL |
Character |
10 |
|
SCO_0495 |
|
3 |
PBSG |
Numeric |
7 |
1 |
SCO_0495 |
|
4 |
IDAP |
Numeric |
7 |
1 |
SCO_0495 |
|
5 |
CODE |
Numeric |
7 |
1 |
SCO_0495 |
|
6 |
CODE_OLD |
Numeric |
7 |
1 |
SCO_0495 |
|
7 |
THRD |
Numeric |
7 |
1 |
SCO_0495 |
|
8 |
PROG |
Numeric |
7 |
1 |
SCO_0495 |
|
9 |
SCEN |
Numeric |
7 |
1 |
SCO_0495 |
|
10 |
SCAN_NAME |
Character |
30 |
|
SCO_0495 |
|
11 |
COMMENTS |
Character |
120 |
|
SCO_0495 |
|
1 |
SECT |
Character |
4 |
|
EXAM0494 |
|
2 |
AREA |
Character |
4 |
|
EXAM0494 |
|
3 |
POINTS |
Numeric |
3 |
1 |
EXAM0494 |
|
4 |
QUES |
Numeric |
5 |
|
EXAM0494 |
|
5 |
PICKED |
Logical |
1 |
|
EXAM0494 |
|
6 |
SEQ |
Numeric |
3 |
|
EXAM0494 |
|
1 |
A |
Character |
11 |
|
FIDER |
|
2 |
B |
Character |
11 |
|
FIDER |
|
3 |
C |
Character |
12 |
|
FIDER |
|
4 |
D |
Character |
6 |
|
FIDER |
|
5 |
E |
Character |
11 |
|
FIDER |
|
6 |
F |
Character |
38 |
|
FIDER |
|
7 |
G |
Character |
50 |
|
FIDER |
|
8 |
H |
Character |
14 |
|
FIDER |
|
9 |
I |
Character |
14 |
|
FIDER |
|
10 |
J |
Character |
23 |
|
FIDER |
|
11 |
K |
Character |
31 |
|
FIDER |
|
12 |
L |
Character |
12 |
|
FIDER |
|
13 |
M |
Character |
5 |
|
FIDER |
|
14 |
N |
Character |
11 |
|
FIDER |
|
15 |
O |
Character |
7 |
|
FIDER |
|
16 |
P |
Character |
12 |
|
FIDER |
|
1 |
COLLNAME |
Character |
60 |
|
FIDERP2 |
|
2 |
NAME |
Character |
42 |
|
FIDERP2 |
|
3 |
F |
Character |
34 |
|
FIDERP2 |
|
4 |
G |
Character |
42 |
|
FIDERP2 |
|
5 |
H |
Character |
66 |
|
FIDERP2 |
|
6 |
I |
Character |
52 |
|
FIDERP2 |
|
7 |
J |
Character |
36 |
|
FIDERP2 |
|
8 |
K |
Character |
35 |
|
FIDERP2 |
|
9 |
L |
Character |
17 |
|
FIDERP2 |
|
10 |
M |
Character |
5 |
|
FIDERP2 |
|
11 |
N |
Character |
11 |
|
FIDERP2 |
|
12 |
O |
Character |
7 |
|
FIDERP2 |
|
1 |
A |
Character |
60 |
|
FIDERPRO |
|
2 |
B |
Character |
14 |
|
FIDERPRO |
|
3 |
C |
Character |
42 |
|
FIDERPRO |
|
4 |
D |
Character |
11 |
|
FIDERPRO |
|
5 |
E |
Character |
44 |
|
FIDERPRO |
|
6 |
F |
Character |
34 |
|
FIDERPRO |
|
7 |
G |
Character |
42 |
|
FIDERPRO |
|
8 |
H |
Character |
66 |
|
FIDERPRO |
|
9 |
I |
Character |
52 |
|
FIDERPRO |
|
10 |
J |
Character |
36 |
|
FIDERPRO |
|
11 |
K |
Character |
35 |
|
FIDERPRO |
|
12 |
L |
Character |
17 |
|
FIDERPRO |
|
13 |
M |
Character |
5 |
|
FIDERPRO |
|
14 |
N |
Character |
11 |
|
FIDERPRO |
|
15 |
O |
Character |
7 |
|
FIDERPRO |
|
16 |
P |
Character |
134 |
|
FIDERPRO |
|
1 |
CONTROL_NO |
Character |
6 |
|
FLORIDA |
|
1 |
TYPE |
Character |
12 |
|
FOXUSER |
|
2 |
ID |
Character |
12 |
|
FOXUSER |
|
3 |
NAME |
Character |
24 |
|
FOXUSER |
|
4 |
READONLY |
Logical |
1 |
|
FOXUSER |
|
5 |
CKVAL |
Numeric |
6 |
|
FOXUSER |
|
6 |
DATA |
Memo |
10 |
|
FOXUSER |
|
7 |
UPDATED |
Date |
8 |
|
FOXUSER |
|
1 |
SECT |
Character |
4 |
|
IDAP0497 |
|
2 |
AREA |
Character |
4 |
|
IDAP0497 |
|
3 |
POINTS |
Numeric |
3 |
1 |
IDAP0497 |
|
4 |
QUES |
Numeric |
5 |
|
IDAP0497 |
|
5 |
PICKED |
Logical |
1 |
|
IDAP0497 |
|
6 |
SEQ |
Numeric |
3 |
|
IDAP0497 |
|
7 |
D_LASTUSED |
Date |
8 |
|
IDAP0497 |
|
1 |
SECT |
Character |
4 |
|
IDAP0498 |
|
2 |
AREA |
Character |
4 |
|
IDAP0498 |
|
3 |
POINTS |
Numeric |
3 |
1 |
IDAP0498 |
|
4 |
QUES |
Numeric |
5 |
|
IDAP0498 |
|
5 |
PICKED |
Logical |
1 |
|
IDAP0498 |
|
6 |
SEQ |
Numeric |
3 |
|
IDAP0498 |
|
7 |
D_LASTUSED |
Date |
8 |
|
IDAP0498 |
|
1 |
SECT |
Character |
4 |
|
IDAP0895 |
|
2 |
AREA |
Character |
4 |
|
IDAP0895 |
|
3 |
POINTS |
Numeric |
3 |
1 |
IDAP0895 |
|
4 |
QUES |
Numeric |
5 |
|
IDAP0895 |
|
5 |
PICKED |
Logical |
1 |
|
IDAP0895 |
|
6 |
SEQ |
Numeric |
3 |
|
IDAP0895 |
|
7 |
D_LASTUSED |
Date |
8 |
|
IDAP0895 |
|
1 |
SECT |
Character |
4 |
|
IDAP1095 |
|
2 |
AREA |
Character |
4 |
|
IDAP1095 |
|
3 |
POINTS |
Numeric |
3 |
1 |
IDAP1095 |
|
4 |
QUES |
Numeric |
5 |
|
IDAP1095 |
|
5 |
PICKED |
Logical |
1 |
|
IDAP1095 |
|
6 |
SEQ |
Numeric |
3 |
|
IDAP1095 |
|
7 |
D_LASTUSED |
Date |
8 |
|
IDAP1095 |
|
1 |
SECT |
Character |
4 |
|
IDAP1096 |
|
2 |
AREA |
Character |
4 |
|
IDAP1096 |
|
3 |
POINTS |
Numeric |
3 |
1 |
IDAP1096 |
|
4 |
QUES |
Numeric |
5 |
|
IDAP1096 |
|
5 |
PICKED |
Logical |
1 |
|
IDAP1096 |
|
6 |
SEQ |
Numeric |
3 |
|
IDAP1096 |
|
7 |
D_LASTUSED |
Date |
8 |
|
IDAP1096 |
|
1 |
NAME |
Character |
40 |
Asc |
IIDA |
|
2 |
DATE_COURS |
Date |
8 |
|
IIDA |
|
3 |
COURSE_NO |
Character |
8 |
|
IIDA |
|
4 |
LOC_CITY |
Character |
15 |
|
IIDA |
|
5 |
LOC_ST |
Character |
2 |
|
IIDA |
|
6 |
MAIN_ADDR1 |
Character |
40 |
|
IIDA |
|
7 |
MAIN_ADDR2 |
Character |
40 |
|
IIDA |
|
8 |
CITY |
Character |
20 |
|
IIDA |
|
9 |
STATE |
Character |
2 |
|
IIDA |
|
10 |
ZIP |
Character |
10 |
|
IIDA |
|
11 |
POSTAL |
Character |
7 |
|
IIDA |
|
12 |
PHONE |
Character |
10 |
|
IIDA |
|
13 |
CAN_NO |
Character |
10 |
|
IIDA |
|
14 |
ENTRY |
Character |
4 |
|
IIDA |
|
15 |
AFF |
Character |
42 |
|
IIDA |
|
16 |
AFF_OTHR |
Character |
7 |
|
IIDA |
|
17 |
EMP_NAME |
Character |
40 |
|
IIDA |
|
18 |
EMP_ADDR |
Character |
40 |
|
IIDA |
|
19 |
EMP_CITY |
Character |
20 |
|
IIDA |
|
20 |
EMP_ST |
Character |
2 |
|
IIDA |
|
21 |
EMP_ZIP |
Character |
10 |
|
IIDA |
|
22 |
EMP_POSTAL |
Character |
7 |
|
IIDA |
|
23 |
RATE |
Numeric |
1 |
|
IIDA |
|
24 |
IN_DBF |
Logical |
1 |
|
IIDA |
|
25 |
CERTIF |
Logical |
1 |
|
IIDA |
|
26 |
PROCESSED |
Date |
8 |
|
IIDA |
|
27 |
ASID |
Logical |
1 |
|
IIDA |
|
28 |
IDC |
Logical |
1 |
|
IIDA |
|
29 |
IDEC |
Logical |
1 |
|
IIDA |
|
30 |
IIDA |
Logical |
1 |
|
IIDA |
|
1 |
SECT |
Character |
4 |
|
IDAP1097 |
|
2 |
AREA |
Character |
4 |
|
IDAP1097 |
|
3 |
POINTS |
Numeric |
3 |
1 |
IDAP1097 |
|
4 |
QUES |
Numeric |
5 |
|
IDAP1097 |
|
5 |
PICKED |
Logical |
1 |
|
IDAP1097 |
|
6 |
SEQ |
Numeric |
3 |
|
IDAP1097 |
|
7 |
D_LASTUSED |
Date |
8 |
|
IDAP1097 |
|
1 |
SECT |
Character |
4 |
|
IDAP1098 |
|
2 |
AREA |
Character |
4 |
|
IDAP1098 |
|
3 |
POINTS |
Numeric |
3 |
1 |
IDAP1098 |
|
4 |
QUES |
Numeric |
5 |
|
IDAP1098 |
|
5 |
PICKED |
Logical |
1 |
|
IDAP1098 |
|
6 |
SEQ |
Numeric |
3 |
|
IDAP1098 |
|
7 |
D_LASTUSED |
Date |
8 |
|
IDAP1098 |
|
1 |
NAME |
Character |
40 |
|
IIDATEST |
|
2 |
CAN_NO |
Character |
10 |
|
IIDATEST |
|
3 |
DATE_COURS |
Date |
8 |
|
IIDATEST |
|
4 |
SPONSOR |
Character |
10 |
|
IIDATEST |
|
5 |
COURSE_NO |
Character |
4 |
|
IIDATEST |
|
6 |
TITLE |
Character |
65 |
|
IIDATEST |
|
7 |
CREDITS |
Numeric |
4 |
1 |
IIDATEST |
|
1 |
CONTROL_NO |
Character |
6 |
|
REV_1992 |
|
2 |
OLDCONTROL |
Character |
10 |
|
REV_1992 |
|
3 |
D_ENTERED |
Date |
8 |
|
REV_1992 |
|
4 |
D_REVIEW |
Date |
8 |
|
REV_1992 |
|
5 |
T_IN_HR |
Character |
2 |
|
REV_1992 |
|
6 |
T_IN_MIN |
Character |
2 |
|
REV_1992 |
|
7 |
T_OUT_HR |
Character |
2 |
|
REV_1992 |
|
8 |
T_OUT_MIN |
Character |
2 |
|
REV_1992 |
|
9 |
T_IN_AM |
Character |
2 |
|
REV_1992 |
|
10 |
T_OUT_AM |
Character |
2 |
|
REV_1992 |
|
11 |
T_IN_PM |
Character |
2 |
|
REV_1992 |
|
12 |
T_OUT_PM |
Character |
2 |
|
REV_1992 |
|
13 |
R_CODE |
Character |
1 |
|
REV_1992 |
|
14 |
R_PBSG |
Character |
1 |
|
REV_1992 |
|
15 |
R_IDAP |
Character |
1 |
|
REV_1992 |
|
16 |
R_SCEN |
Character |
1 |
|
REV_1992 |
|
17 |
R_THRD |
Character |
1 |
|
REV_1992 |
|
18 |
R_PROG |
Character |
1 |
|
REV_1992 |
|
19 |
CHECK_NO |
Character |
6 |
|
REV_1992 |
|
20 |
CHECK_AMT |
Character |
6 |
|
REV_1992 |
|
21 |
STATE_REV |
Character |
2 |
|
REV_1992 |
|
1 |
CENTER |
Character |
3 |
|
CEN_0493 |
|
2 |
CENT_NAME |
Character |
30 |
|
CEN_0493 |
|
3 |
D_ENTERED |
Date |
8 |
|
CEN_0493 |
|
4 |
D_MODIFIED |
Date |
8 |
|
CEN_0493 |
|
5 |
W_MODIFIED |
Character |
8 |
|
CEN_0493 |
|
6 |
D_CONFIRM |
Date |
8 |
|
CEN_0493 |
|
7 |
L1_NAME |
Character |
30 |
|
CEN_0493 |
|
8 |
L1_STREET |
Character |
30 |
|
CEN_0493 |
|
9 |
L1_ROOM |
Character |
30 |
|
CEN_0493 |
|
10 |
L1_CITY |
Character |
15 |
|
CEN_0493 |
|
11 |
L1_STATE |
Character |
2 |
|
CEN_0493 |
|
12 |
L1_ZIP |
Character |
10 |
|
CEN_0493 |
|
13 |
L1_COUNTRY |
Character |
6 |
|
CEN_0493 |
|
14 |
L1_PHONE |
Character |
10 |
|
CEN_0493 |
|
15 |
L2_NAME |
Character |
30 |
|
CEN_0493 |
|
16 |
L2_STREET |
Character |
30 |
|
CEN_0493 |
|
17 |
L2_ROOM |
Character |
30 |
|
CEN_0493 |
|
18 |
L2_CITY |
Character |
15 |
|
CEN_0493 |
|
19 |
L2_STATE |
Character |
2 |
|
CEN_0493 |
|
20 |
L2_ZIP |
Character |
10 |
|
CEN_0493 |
|
21 |
L2_COUNTRY |
Character |
6 |
|
CEN_0493 |
|
22 |
L2_PHONE |
Character |
10 |
|
CEN_0493 |
|
23 |
CH_FNAME |
Character |
15 |
|
CEN_0493 |
|
24 |
CH_LNAME |
Character |
15 |
|
CEN_0493 |
|
25 |
CH_FIRM |
Character |
30 |
|
CEN_0493 |
|
26 |
CH_ADDR |
Character |
30 |
|
CEN_0493 |
|
27 |
CH_CITY |
Character |
15 |
|
CEN_0493 |
|
28 |
CH_STATE |
Character |
2 |
|
CEN_0493 |
|
29 |
CH_ZIP |
Character |
10 |
|
CEN_0493 |
|
30 |
CH_COUNTRY |
Character |
6 |
|
CEN_0493 |
|
31 |
CH_PHONE1 |
Character |
10 |
|
CEN_0493 |
|
32 |
CH_PHONE2 |
Character |
10 |
|
CEN_0493 |
|
33 |
CH_FAX |
Character |
10 |
|
CEN_0493 |
|
34 |
SHP_FLAG |
Character |
3 |
|
CEN_0493 |
|
35 |
AUX_FLAG |
Character |
3 |
|
CEN_0493 |
|
36 |
CH_FULNAME |
Character |
30 |
|
CEN_0493 |
|
37 |
CH_SAL |
Character |
3 |
|
CEN_0493 |
|
1 |
CONTROL_NO |
Character |
6 |
|
REV_1991 |
|
2 |
OLDCONTROL |
Character |
10 |
|
REV_1991 |
|
3 |
D_ENTERED |
Date |
8 |
|
REV_1991 |
|
4 |
D_REVIEW |
Date |
8 |
|
REV_1991 |
|
5 |
T_IN_HR |
Character |
2 |
|
REV_1991 |
|
6 |
T_IN_MIN |
Character |
2 |
|
REV_1991 |
|
7 |
T_OUT_HR |
Character |
2 |
|
REV_1991 |
|
8 |
T_OUT_MIN |
Character |
2 |
|
REV_1991 |
|
9 |
T_IN_AM |
Character |
2 |
|
REV_1991 |
|
10 |
T_OUT_AM |
Character |
2 |
|
REV_1991 |
|
11 |
T_IN_PM |
Character |
2 |
|
REV_1991 |
|
12 |
T_OUT_PM |
Character |
2 |
|
REV_1991 |
|
13 |
R_CODE |
Character |
1 |
|
REV_1991 |
|
14 |
R_PBSG |
Character |
1 |
|
REV_1991 |
|
15 |
R_IDAP |
Character |
1 |
|
REV_1991 |
|
16 |
R_SCEN |
Character |
1 |
|
REV_1991 |
|
17 |
R_THRD |
Character |
1 |
|
REV_1991 |
|
18 |
R_PROG |
Character |
1 |
|
REV_1991 |
|
19 |
CHECK_NO |
Character |
6 |
|
REV_1991 |
|
20 |
CHECK_AMT |
Character |
6 |
|
REV_1991 |
|
21 |
STATE_REV |
Character |
2 |
|
REV_1991 |
|
1 |
CODE |
Character |
2 |
Asc |
TRT |
|
2 |
DESC |
Character |
30 |
|
TRT |
|
1 |
CENTER |
Character |
3 |
|
CEN_1093 |
|
2 |
CENT_NAME |
Character |
30 |
|
CEN_1093 |
|
3 |
D_ENTERED |
Date |
8 |
|
CEN_1093 |
|
4 |
D_MODIFIED |
Date |
8 |
|
CEN_1093 |
|
5 |
W_MODIFIED |
Character |
8 |
|
CEN_1093 |
|
6 |
D_CONFIRM |
Date |
8 |
|
CEN_1093 |
|
7 |
L1_NAME |
Character |
30 |
|
CEN_1093 |
|
8 |
L1_STREET |
Character |
30 |
|
CEN_1093 |
|
9 |
L1_ROOM |
Character |
30 |
|
CEN_1093 |
|
10 |
L1_CITY |
Character |
15 |
|
CEN_1093 |
|
11 |
L1_STATE |
Character |
2 |
|
CEN_1093 |
|
12 |
L1_ZIP |
Character |
10 |
|
CEN_1093 |
|
13 |
L1_COUNTRY |
Character |
6 |
|
CEN_1093 |
|
14 |
L1_PHONE |
Character |
10 |
|
CEN_1093 |
|
15 |
L2_NAME |
Character |
30 |
|
CEN_1093 |
|
16 |
L2_STREET |
Character |
30 |
|
CEN_1093 |
|
17 |
L2_ROOM |
Character |
30 |
|
CEN_1093 |
|
18 |
L2_CITY |
Character |
15 |
|
CEN_1093 |
|
19 |
L2_STATE |
Character |
2 |
|
CEN_1093 |
|
20 |
L2_ZIP |
Character |
10 |
|
CEN_1093 |
|
21 |
L2_COUNTRY |
Character |
6 |
|
CEN_1093 |
|
22 |
L2_PHONE |
Character |
10 |
|
CEN_1093 |
|
23 |
CH_FNAME |
Character |
15 |
|
CEN_1093 |
|
24 |
CH_LNAME |
Character |
15 |
|
CEN_1093 |
|
25 |
CH_FIRM |
Character |
30 |
|
CEN_1093 |
|
26 |
CH_ADDR |
Character |
30 |
|
CEN_1093 |
|
27 |
CH_CITY |
Character |
15 |
|
CEN_1093 |
|
28 |
CH_STATE |
Character |
2 |
|
CEN_1093 |
|
29 |
CH_ZIP |
Character |
10 |
|
CEN_1093 |
|
30 |
CH_COUNTRY |
Character |
6 |
|
CEN_1093 |
|
31 |
CH_PHONE1 |
Character |
10 |
|
CEN_1093 |
|
32 |
CH_PHONE2 |
Character |
10 |
|
CEN_1093 |
|
33 |
CH_FAX |
Character |
10 |
|
CEN_1093 |
|
34 |
SHP_FLAG |
Character |
3 |
|
CEN_1093 |
|
35 |
AUX_FLAG |
Character |
3 |
|
CEN_1093 |
|
36 |
CH_FULNAME |
Character |
30 |
|
CEN_1093 |
|
37 |
CH_SAL |
Character |
3 |
|
CEN_1093 |
|
1 |
AREA |
Character |
4 |
Asc |
EXAMAREA |
|
2 |
DESC |
Character |
50 |
|
EXAMAREA |
|
3 |
PT_ALLOW |
Character |
11 |
|
EXAMAREA |
|
4 |
CODE |
Numeric |
3 |
|
EXAMAREA |
|
5 |
IDAP |
Numeric |
3 |
|
EXAMAREA |
|
6 |
PBSG |
Numeric |
3 |
|
EXAMAREA |
|
7 |
NOTUSED |
Logical |
1 |
|
EXAMAREA |
|
1 |
CERT_NO |
Character |
6 |
|
CANADA99 |
|
2 |
CONTROL_NO |
Character |
6 |
|
CANADA99 |
|
3 |
NAME |
Character |
40 |
|
CANADA99 |
|
4 |
MAIN_ADDR1 |
Character |
40 |
|
CANADA99 |
|
5 |
MAIN_ADDR2 |
Character |
40 |
|
CANADA99 |
|
6 |
MAIN_CITY |
Character |
26 |
|
CANADA99 |
|
7 |
MAIN_STATE |
Character |
2 |
|
CANADA99 |
|
8 |
MAIN_ZIP |
Character |
10 |
|
CANADA99 |
|
1 |
NAME |
Character |
40 |
|
LAJURY98 |
|
2 |
MAIN_ADDR1 |
Character |
40 |
|
LAJURY98 |
|
3 |
MAIN_ADDR2 |
Character |
40 |
|
LAJURY98 |
|
4 |
MAIN_CITY |
Character |
26 |
|
LAJURY98 |
|
5 |
MAIN_STATE |
Character |
2 |
|
LAJURY98 |
|
6 |
MAIN_ZIP |
Character |
10 |
|
LAJURY98 |
|
7 |
MAIN_PHONE |
Character |
12 |
|
LAJURY98 |
|
1 |
EMAIL |
Character |
50 |
|
LISTBOT |
|
1 |
NAME |
Character |
40 |
Asc |
DIRECTOR |
|
2 |
FIRM |
Character |
30 |
|
DIRECTOR |
|
3 |
ADDR |
Character |
30 |
|
DIRECTOR |
|
4 |
CITY |
Character |
15 |
|
DIRECTOR |
|
5 |
ST |
Character |
2 |
|
DIRECTOR |
|
6 |
ZIP |
Character |
10 |
|
DIRECTOR |
|
7 |
PHONE_HOME |
Character |
10 |
|
DIRECTOR |
|
8 |
PHONE_BUS |
Character |
10 |
|
DIRECTOR |
|
9 |
PHONE_FAX |
Character |
10 |
|
DIRECTOR |
|
10 |
TERM |
Character |
9 |
|
DIRECTOR |
|
11 |
COMM1 |
Character |
30 |
|
DIRECTOR |
|
12 |
COMM2 |
Character |
30 |
|
DIRECTOR |
|
13 |
COMM3 |
Character |
30 |
|
DIRECTOR |
|
14 |
LAST_NAME |
Character |
30 |
|
DIRECTOR |
|
15 |
REPRESENTS |
Character |
20 |
|
DIRECTOR |
|
16 |
COUNTRY |
Character |
10 |
|
DIRECTOR |
|
17 |
STATUS |
Character |
4 |
|
DIRECTOR |
|
18 |
CODE |
Character |
6 |
|
DIRECTOR |
|
19 |
X1 |
Character |
1 |
|
DIRECTOR |
|
20 |
X2 |
Character |
1 |
|
DIRECTOR |
|
21 |
STATE_NAME |
Character |
24 |
|
DIRECTOR |
|
22 |
D_MODIFIED |
Date |
8 |
|
DIRECTOR |
|
23 |
W_MODIFIED |
Character |
8 |
|
DIRECTOR |
|
24 |
D_ENTERED |
Date |
8 |
|
DIRECTOR |
|
25 |
W_ENTERED |
Character |
8 |
|
DIRECTOR |
|
1 |
VEND_CODE |
Character |
6 |
|
VOUCHER |
|
2 |
DATE |
Date |
8 |
|
VOUCHER |
|
3 |
AMNT |
Numeric |
9 |
2 |
VOUCHER |
|
4 |
ACCT_NO |
Character |
6 |
|
VOUCHER |
|
5 |
CHECK_NO |
Character |
6 |
|
VOUCHER |
|
6 |
MEMO1 |
Character |
30 |
|
VOUCHER |
|
7 |
MEMO2 |
Character |
30 |
|
VOUCHER |
|
1 |
CONTROL_NO |
Character |
6 |
|
CHECK_IN |
|
2 |
SECT |
Character |
4 |
|
CHECK_IN |
|
3 |
CENTER |
Numeric |
3 |
|
CHECK_IN |
|
4 |
USER |
Character |
8 |
|
CHECK_IN |
|
5 |
DATE |
Date |
8 |
|
CHECK_IN |
|
1 |
SECT |
Character |
4 |
|
Z$SCA |
|
2 |
CONTROL_NO |
Character |
6 |
|
Z$SCA |
|
3 |
SUFFIX |
Character |
4 |
|
Z$SCA |
|
4 |
CENTER |
Numeric |
3 |
|
Z$SCA |
|
5 |
SCORE |
Numeric |
7 |
1 |
Z$SCA |
|
6 |
PASSED |
Logical |
1 |
|
Z$SCA |
|
7 |
W_CHECKIN |
Character |
8 |
|
Z$SCA |
|
8 |
D_CHECKIN |
Date |
8 |
|
Z$SCA |
|
9 |
W_SCANNED |
Character |
8 |
|
Z$SCA |
|
10 |
D_SCANNED |
Date |
8 |
|
Z$SCA |
|
11 |
W_SCORED |
Character |
8 |
|
Z$SCA |
|
12 |
D_SCORED |
Date |
8 |
|
Z$SCA |
|
13 |
SCAN_NAME |
Character |
30 |
|
Z$SCA |
|
14 |
RESPONSES |
Character |
130 |
|
Z$SCA |
|
15 |
JUROR |
Character |
5 |
|
Z$SCA |
|
16 |
U_QTR |
Logical |
1 |
|
Z$SCA |
|
17 |
L_QTR |
Logical |
1 |
|
Z$SCA |
|
1 |
D_EXAM |
Character |
6 |
|
EXAM_SYS |
|
2 |
SECT |
Character |
4 |
|
EXAM_SYS |
|
3 |
DATE |
Date |
8 |
|
EXAM_SYS |
|
4 |
TOT_QUES |
Numeric |
4 |
|
EXAM_SYS |
|
5 |
TOT_PTS |
Numeric |
7 |
1 |
EXAM_SYS |
|
6 |
PASS_PTS |
Numeric |
7 |
1 |
EXAM_SYS |
|
7 |
LOCKED |
Logical |
1 |
|
EXAM_SYS |
|
1 |
D_EXAM |
Character |
6 |
|
EXAM_USE |
|
2 |
SECT |
Character |
4 |
|
EXAM_USE |
|
3 |
SEQ |
Numeric |
3 |
|
EXAM_USE |
|
4 |
QUES |
Numeric |
5 |
|
EXAM_USE |
|
5 |
DIFF_FACT |
Numeric |
6 |
3 |
EXAM_USE |
|
6 |
COMMENTS |
Character |
30 |
|
EXAM_USE |
|
7 |
ANSWER |
Character |
6 |
|
EXAM_USE |
|
8 |
POINTS |
Numeric |
4 |
1 |
EXAM_USE |
|
9 |
AREA |
Character |
4 |
|
EXAM_USE |
|
1 |
CONTROL_NO |
Character |
6 |
Asc |
SCO_1093 |
|
2 |
OLDCONTROL |
Character |
10 |
|
SCO_1093 |
|
3 |
PBSG |
Numeric |
7 |
1 |
SCO_1093 |
|
4 |
IDAP |
Numeric |
7 |
1 |
SCO_1093 |
|
5 |
CODE |
Numeric |
7 |
1 |
SCO_1093 |
|
6 |
CODE_OLD |
Numeric |
7 |
1 |
SCO_1093 |
|
7 |
THRD |
Numeric |
7 |
1 |
SCO_1093 |
|
8 |
PROG |
Numeric |
7 |
1 |
SCO_1093 |
|
9 |