CPS_SCHOOL_CODESFA_SUBMITTAL_DTSFA_NSLDS_SEQ_NBRSFA_NSLDSREQTRL(SQL Table) |
Index Back |
|---|---|
NSLDS request file trailerSFA_NSLDSREQTRL is used as the staging table/trailer record file layout for NSLDS FAH/TM requests. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CPS_SCHOOL_CODE |
Character(6) | VARCHAR2(6) NOT NULL | CPS School Code. Also known as Title IV School Code |
| 2 | SFA_SUBMITTAL_DT |
Date(10) | DATE | NSLDS Request file submittal date. |
| 3 | SFA_NSLDS_SEQ_NBR |
Number(2,0) | SMALLINT NOT NULL | NSLDS Request File sequence number (up to 99 per given submittal date). |
| 4 | NSLDS_REC_COUNT | Character(9) | VARCHAR2(9) NOT NULL | NSLDS Record Count |