SFA_NSLDSRQ_AET

(SQL Table)
Index Back

State Rec for NSLDS Req Prcs

State Record for NSLDS Request Process

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 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

5 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

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

Prompt Table: %EDITTABLE

7 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

8 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
9 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
10 SCCPS_FILE_PATH Character(254) VARCHAR2(254) NOT NULL Pop Select File Path and Name
11 SFA_NSLDS_SEQ_NBR Number(2,0) SMALLINT NOT NULL NSLDS Request File sequence number (up to 99 per given submittal date).
12 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

Default Value: OPR_DEF_TBL_CS.AID_YEAR

Prompt Table: FED_AID_YR_TBL

13 CPS_SCHOOL_CODE Character(6) VARCHAR2(6) NOT NULL CPS School Code. Also known as Title IV School Code

Prompt Table: INST_SCHOOL_CDS

14 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: %EDITTABLE2

15 FILE_PATH Character(127) VARCHAR2(127) NOT NULL Input/Output file path
16 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: OPR_DEF_TBL_CS.INSTITUTION

Prompt Table: INSTITUTION_TBL

17 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

18 SFA_LAST_NSLDS_SEQ Character(2) VARCHAR2(2) NOT NULL Last Seuqence Number used
19 SFA_LAST_SUBMIT_DT Date(10) DATE Last Submittal Date
20 SFA_TM_BEGIN_DT Date(10) DATE FA-Aggregates: Transfer Monitoring Begin Date
21 TERM_BEGIN_DT Date(10) DATE Enrollment Date
22 SFA_NSLDS_ENROL_DT Character(8) VARCHAR2(8) NOT NULL NSLDS Transfer Monitoring Request enrollment start date.
23 SFA_TM_BEGIN_CHRDT Character(8) VARCHAR2(8) NOT NULL Transfer Monitoring begin date - character representation.
24 SFA_SUBMITTAL_DT Date(10) DATE NSLDS Request file submittal date.
25 SFA_BRANCH_CODE Character(2) VARCHAR2(2) NOT NULL Branch Code

Default Value: 00

26 SFA_TM_DELETE Character(1) VARCHAR2(1) NOT NULL FA-Aggregates: Remove student from Transfer Monitoring Alert List (Y/N).
27 STDNT_OVRD Character(1) VARCHAR2(1) NOT NULL Student Override

Default Value: N

28 NSLDS_REC_CNT Number(9,0) DECIMAL(9) NOT NULL NSLDS Record Count
29 DATETIME_STAMP DateTime(26) TIMESTAMP DateTime Stamp