SFA_SLC_RC_SSAC

(SQL Table)
Index Back

SLC SSAC Run Control

Student Loans Company (SLC) Run Control record for SSAC processing.

# 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
3 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

4 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

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

Prompt Table: %EDITTABLE

6 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

7 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
8 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
9 SCCPS_FILE_PATH Character(254) VARCHAR2(254) NOT NULL Pop Select File Path and Name
10 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: OPR_DEF_TBL_CS.INSTITUTION

Prompt Table: INSTITUTION_TBL

11 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

Default Value: OPR_DEF_TBL_CS.AID_YEAR

Prompt Table: AID_YEAR_TBL

12 SFA_SLC_HEI_CD Character(4) VARCHAR2(4) NOT NULL HEI Code

Prompt Table: SFA_SLC_HEI_VW

13 SFA_SLC_PROC_OPT Character(1) VARCHAR2(1) NOT NULL Process Option
1=Populate and Export
2=Populate Only
3=Export Only

Default Value: 1

14 SFA_FILE_PATH Character(250) VARCHAR2(250) NOT NULL File Path
15 SFA_SLC_LOC_CD Character(2) VARCHAR2(2) NOT NULL Location Code

Default Value: 01

16 SFA_SLC_1ATT_CONF Character(1) VARCHAR2(1) NOT NULL Field to determine if the SSAC proces is confirming attendance for 1st liability.

Y/N Table Edit

Default Value: N