SFA_SLC_RC_ACRX

(SQL Table)
Index Back

SLC ACR Export Run Control

Student Loans Company (SLC) Run Control for ACR Export 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 SFA_SLC_HEI_CD Character(4) VARCHAR2(4) NOT NULL HEI Code

Prompt Table: SFA_SLC_HEI_VW

4 SFA_SLC_ACAD_YR Character(4) VARCHAR2(4) NOT NULL SLC Acad Year

Prompt Table: SFA_SLC_ACYR_VW

5 SFA_SLC_ISSUE_DT Date(10) DATE NOT NULL Issue Date

Prompt Table: SFA_SLC_ACRDTVW

6 SFA_FILE_PATH Character(250) VARCHAR2(250) NOT NULL File Path
7 SFA_SLC_LIAB_PRD Character(1) VARCHAR2(1) NOT NULL Liability Period
1=1
2=2
3=3

Default Value: 1

8 SFA_SLC_ACAD_LOAD Character(1) VARCHAR2(1) NOT NULL Academic Load
B=Both Full Time and Part Time
F=Full Time
N=None
P=Part Time

Default Value: B

9 SFA_SLC_ADM_DT_OVR Date(10) DATE Admit Date Override
10 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

11 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

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

Prompt Table: %EDITTABLE

13 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

14 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
15 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
16 SCCPS_FILE_PATH Character(254) VARCHAR2(254) NOT NULL Pop Select File Path and Name
17 SFA_SLC_POP_SEL Character(1) VARCHAR2(1) NOT NULL Pop Select Checkbox for SLC

Y/N Table Edit

Default Value: N