DL_PROCESS_DATE_0DL_SEQ_NBRDL_EXIT_HDR_EC(SQL Table) |
Index Back |
|---|---|
DL Exit Counseling Header |
| # | 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_REC_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Statement Record Type |
| 4 | DL_HEADER_TITLE | Character(40) | VARCHAR2(40) NOT NULL | Header Title |
| 5 | DL_REPORT_ID | Character(6) | VARCHAR2(6) NOT NULL | Report Id |
| 6 | DL_SCHOOL_CD | Character(6) | VARCHAR2(6) NOT NULL | School Code |
| 7 | DL_SCHOOL_BRNCH_ID | Character(2) | VARCHAR2(2) NOT NULL | School Branch ID |
| 8 | DL_BEDGIN_DATE | Character(8) | VARCHAR2(8) NOT NULL | Begin Date |
| 9 | DL_END_DATE | Character(8) | VARCHAR2(8) NOT NULL | End Date |
| 10 | DL_SSN | Character(9) | VARCHAR2(9) NOT NULL | DL SSN |
| 11 | DL_EXTRACT_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Extract Type |
| 12 | DL_SUBMITTAL_DATE | Character(8) | VARCHAR2(8) NOT NULL | Submittal Date |
| 13 | DL_SUBMITTAL_TIME | Character(8) | VARCHAR2(8) NOT NULL | Submittal Time |
| 14 | DL_LENDER_SRVCR_ID | Character(6) | VARCHAR2(6) NOT NULL | Lender Servicer ID |
| 15 | DL_LENDER_ID | Character(6) | VARCHAR2(6) NOT NULL | Lender ID |
| 16 | DL_LN_SERVICER_ID | Character(3) | VARCHAR2(3) NOT NULL | Loan Servicer ID |