SFA_NSLDSREQ_R

(SQL Table)
Index Back

Temp Table for SFA_NSLDSREQ

Temp Table to hold population for NSLDS data request processes (TM and FAH).

  • Parent record: SFA_NSLDSREQHDR
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: SFA_NSLDS_STUVW

    4 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
    5 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
    6 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    7 BIRTHDATE Date(10) DATE Date of Birth
    8 TERM_BEGIN_DT Date(10) DATE Term Begin Date
    9 SFA_NSLDS_ENROL_DT Character(8) VARCHAR2(8) NOT NULL NSLDS Transfer Monitoring Request enrollment start date.
    10 SFA_TM_BEGIN_DT Date(10) DATE FA-Aggregates: Transfer Monitoring Begin Date
    11 SFA_TM_BEGIN_CHRDT Character(8) VARCHAR2(8) NOT NULL Transfer Monitoring begin date - character representation.
    12 SFA_TM_DELETE Character(1) VARCHAR2(1) NOT NULL FA-Aggregates: Remove student from Transfer Monitoring Alert List (Y/N).

    Y/N Table Edit

    Default Value: N

    13 CPS_SCHOOL_CODE Character(6) VARCHAR2(6) NOT NULL CPS School Code. Also known as Title IV School Code
    14 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
    15 SFA_BRANCH_CODE Character(2) VARCHAR2(2) NOT NULL Branch Code