DL_EXIT_DTL_EC(SQL Table) |
Index Back |
|---|---|
DL Exit Counseling Detail |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  DL_PROCESS_DATE_0 |
Date(10) | DATE | DL Process Date |
| 2 | DL_SEQ_NBR |
Number(9,0) | DECIMAL(9) NOT NULL | Sequence Number |
| 3 | DL_DTL_SEQNBR |
Number(9,0) | DECIMAL(9) NOT NULL | Detail Sequence Number |
| 4 | DL_REC_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Statement Record Type |
| 5 | DL_STU_SSN | Character(9) | VARCHAR2(9) NOT NULL | Student's SSN |
| 6 | DL_STDNT_FIRST_NAM | Character(35) | VARCHAR2(35) NOT NULL | First Name |
| 7 | DL_STDNT_MI | Character(35) | VARCHAR2(35) NOT NULL | Middle Initial |
| 8 | DL_STDNT_LAST_NAME | Character(35) | VARCHAR2(35) NOT NULL | Last Name |
| 9 | DL_STU_DOB | Character(8) | VARCHAR2(8) NOT NULL | Student's Date of Birth |
| 10 | DL_SCHOOL_NAME | Character(65) | VARCHAR2(65) NOT NULL | School Name |
| 11 | DL_SCHOOL_CD | Character(6) | VARCHAR2(6) NOT NULL | School Code |
| 12 | DL_SCHOOL_BRNCH_ID | Character(2) | VARCHAR2(2) NOT NULL | School Branch ID |
| 13 | DL_COMPLETION_DATE | Character(8) | VARCHAR2(8) NOT NULL | Completion Date |
| 14 | DL_COMPLETION_TIME | Character(8) | VARCHAR2(8) NOT NULL | Completion Time |
| 15 | DL_MEDIA_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Media Type |
| 16 | DL_SOURCE_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Source Type |
| 17 | DL_DRVR_LIC_NBR | Character(30) | VARCHAR2(30) NOT NULL | Driver License Number |
| 18 | DL_DRVR_LIC_STATE | Character(2) | VARCHAR2(2) NOT NULL | Driver License State |
| 19 | DL_STU_ADDRESS1 | Character(40) | VARCHAR2(40) NOT NULL | Address 1 |
| 20 | DL_STU_ADDRESS2 | Character(40) | VARCHAR2(40) NOT NULL | Address 2 |
| 21 | DL_STU_CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 22 | DL_STU_STATE | Character(2) | VARCHAR2(2) NOT NULL | State |
| 23 | DL_STU_COUNTRY | Character(2) | VARCHAR2(2) NOT NULL | Country |
| 24 | DL_STU_ZIP_CODE | Character(17) | VARCHAR2(17) NOT NULL | Zip Code |
| 25 | DL_STU_PHONE | Character(12) | VARCHAR2(12) NOT NULL | Phone Number |
| 26 | DL_STU_EMAIL | Character(128) | VARCHAR2(128) NOT NULL | |
| 27 | DL_EMPLOYER_NAME | Character(60) | VARCHAR2(60) NOT NULL | Employer Name |
| 28 | DL_EMP_ADDRESS1 | Character(40) | VARCHAR2(40) NOT NULL | Address 1 |
| 29 | DL_EMP_ADDRESS2 | Character(40) | VARCHAR2(40) NOT NULL | Address 2 |
| 30 | DL_EMP_CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 31 | DL_EMP_STATE | Character(2) | VARCHAR2(2) NOT NULL | State |
| 32 | DL_EMP_ZIP_CODE | Character(9) | VARCHAR2(9) NOT NULL | Zip Code |
| 33 | DL_EMP_PHONE | Character(12) | VARCHAR2(12) NOT NULL | Phone Number |
| 34 | DL_KIN_FIRST_NAME | Character(35) | VARCHAR2(35) NOT NULL | First Name |
| 35 | DL_KIN_LAST_NAME | Character(35) | VARCHAR2(35) NOT NULL | Last Name |
| 36 | DL_KIN_ADDRESS1 | Character(40) | VARCHAR2(40) NOT NULL | Address 1 |
| 37 | DL_KIN_ADDRESS2 | Character(40) | VARCHAR2(40) NOT NULL | Address 2 |
| 38 | DL_KIN_CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 39 | DL_KIN_STATE | Character(2) | VARCHAR2(2) NOT NULL | State |
| 40 | DL_KIN_ZIP_CODE | Character(9) | VARCHAR2(9) NOT NULL | Zip Code |
| 41 | DL_KIN_PHONE | Character(10) | VARCHAR2(10) NOT NULL | Phone Number |
| 42 | DL_REF_FIRST_NAME | Character(35) | VARCHAR2(35) NOT NULL | First Name |
| 43 | DL_REF_LAST_NAME | Character(35) | VARCHAR2(35) NOT NULL | Last Name |
| 44 | DL_REF_ADDRESS1 | Character(40) | VARCHAR2(40) NOT NULL | Address 1 |
| 45 | DL_REF_ADDRESS2 | Character(40) | VARCHAR2(40) NOT NULL | Address 2 |
| 46 | DL_REF_CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 47 | DL_REF_STATE | Character(2) | VARCHAR2(2) NOT NULL | State |
| 48 | DL_REF_ZIP_CODE | Character(9) | VARCHAR2(9) NOT NULL | Zip Code |
| 49 | DL_REF_PHONE | Character(10) | VARCHAR2(10) NOT NULL | Phone Number |
| 50 | DL_REF2_FIRST_NAME | Character(35) | VARCHAR2(35) NOT NULL | First Name |
| 51 | DL_REF2_LAST_NAME | Character(35) | VARCHAR2(35) NOT NULL | Last Name |
| 52 | DL_REF2_ADDRESS1 | Character(40) | VARCHAR2(40) NOT NULL | Address 1 |
| 53 | DL_REF2_ADDRESS2 | Character(40) | VARCHAR2(40) NOT NULL | Address 2 |
| 54 | DL_REF2_CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 55 | DL_REF2_STATE | Character(2) | VARCHAR2(2) NOT NULL | State |
| 56 | DL_REF2_ZIP_CODE | Character(9) | VARCHAR2(9) NOT NULL | Zip Code |
| 57 | DL_REF2_PHONE | Character(10) | VARCHAR2(10) NOT NULL | Phone Number |
| 58 | SFA_CR_CNSL_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Counseling Processing Status
1=Student Not Found 2=Multiple Student Matches 3=SearchMatch option set to Skip 4=No Setup 5=No Grad PLUS record found 6=No Stafford record found 7=No Aid Year 8=Cannot Insert/Update data |
| 59 | DL_PROCESS_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Processing Status
E=Error P=Processed S=Skipped Record U=Unprocessed |
| 60 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 61 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 62 | AID_YEAR | Character(4) | VARCHAR2(4) NOT NULL | Aid Year |