SFA_NSLDSREQDTL

(SQL Table)
Index Back

NSLDS request file detail

SFA_NSLDSREQDTL is used as the staging table /detail 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
6 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
7 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
8 BIRTHDATE Date(10) DATE Date of Birth
9 SFA_NSLDS_ENROL_DT Character(8) VARCHAR2(8) NOT NULL NSLDS Transfer Monitoring Request enrollment start date.
10 SFA_TM_BEGIN_CHRDT Character(8) VARCHAR2(8) NOT NULL Transfer Monitoring begin date - character representation.
11 SFA_TM_DELETE Character(1) VARCHAR2(1) NOT NULL FA-Aggregates: Remove student from Transfer Monitoring Alert List (Y/N).
12 SFA_AGGR_RUNOPTION Character(1) VARCHAR2(1) NOT NULL FA-Aggregates Run Control Option
B=Both FAH and TM
H=Financial Aid History only
T=Transfer Monitoring only
13 SFA_BRANCH_CODE Character(2) VARCHAR2(2) NOT NULL Branch Code