SFA_NSLDSRQ_OVD

(SQL Table)
Index Back

NSLDS Student Override Rec

Student Override Record for NSLDS Request Process

  • Parent record: SFA_NSLDSRQ_RC
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Default Value: OPR_DEF_TBL_CS.OPRID

    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

    Default Value: SFA_NSLDSRQ_RC.RUN_CNTL_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_TM_BEGIN_DT Date(10) DATE FA-Aggregates: Transfer Monitoring Begin Date
    10 SFA_NSLDS_ENROL_DT Character(8) VARCHAR2(8) NOT NULL NSLDS Transfer Monitoring Request enrollment start 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 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

    Default Value: H