SFA_RUN_NSLDSUP

(SQL Table)
Index Back

FA Aggr NSLDS Run Control

Run Control record for Aggregate NSLDS data processing.

  • Parent Record Of SFA_RUN_NSLDSST
  • # 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 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

    Default Value: OPR_DEF_TBL_CS.AID_YEAR

    Prompt Table: FED_AID_YR_TBL

    4 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    5 SCCPS_POP_SEL Character(1) VARCHAR2(1) NOT NULL Population Selection checkbox - used to incidate on run controls that pop selection was selected for use.

    Y/N Table Edit

    Default Value: Y

    6 SCCPS_TOOL_ID Number(15,0) DECIMAL(15) NOT NULL Tool ID - the unique key for a pop select tool

    Prompt Table: SCCPS_TOOL_VW

    7 SCCPS_QUERY_NAME Character(50) VARCHAR2(50) NOT NULL Query / Section name used by population selection

    Prompt Table: %EDITTABLE

    8 SCCPS_CNTXT_ID Number(15,0) DECIMAL(15) NOT NULL Context ID - the unique key that identifies the pop selection context

    Prompt Table: SCCPS_CNTXT_VW

    9 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
    10 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
    11 SCCPS_FILE_PATH Character(254) VARCHAR2(254) NOT NULL Pop Select File Path and Name
    12 SFA_NSLDS_PUSH_TYP Character(1) VARCHAR2(1) NOT NULL FA-Aggregates: NSLDS Data Push Option (Refresh vs. Update)
    R=Refresh NSLDS Data
    U=Update NSLDS Data

    Default Value: U

    13 SFA_OVERRIDE_RULE Character(1) VARCHAR2(1) NOT NULL FA-Aggregates: Preserver Override during NSLDS Data Push

    Y/N Table Edit

    Default Value: N

    14 SFA_PROC_RUN_MODE Character(1) VARCHAR2(1) NOT NULL Flag to indicate process execution mode (Batch vs. Remote Call). Created for the FA External Award Load process.
    B=Batch Process
    R=On-line Process

    Default Value: B

    15 STDNT_OVRD Character(1) VARCHAR2(1) NOT NULL Student Override

    Y/N Table Edit

    Default Value: N