SFA_SLC_AET

(SQL Table)
Index Back

SLC AET Record

Student Loans Company App Engine Record

# 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 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
5 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
6 SFA_SLC_HEI_CD Character(4) VARCHAR2(4) NOT NULL HEI Code
7 SFA_SLC_PROC_OPT Character(1) VARCHAR2(1) NOT NULL Process Option
1=Populate and Export
2=Populate Only
3=Export Only
8 SFA_FILE_PATH Character(250) VARCHAR2(250) NOT NULL File Path
9 SFA_SLC_LOC_CD Character(2) VARCHAR2(2) NOT NULL Location Code
10 SFA_SLC_ACAD_YR Character(4) VARCHAR2(4) NOT NULL SLC Acad Year
11 SFA_FILE_PATH_NAME Character(128) VARCHAR2(128) NOT NULL File Path and Name
12 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

13 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

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

Prompt Table: %EDITTABLE

15 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

16 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
17 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
18 SCCPS_FILE_PATH Character(254) VARCHAR2(254) NOT NULL Pop Select File Path and Name
19 SFA_SLC_CD_RC_OPT Character(1) VARCHAR2(1) NOT NULL Course Database Option
1=Download Course Catalog
2=Fetch Qualifications
3=Submit Data Changes
20 SFA_SLC_TFPR_IND Character(1) VARCHAR2(1) NOT NULL TFPR Indicator
21 SFA_SLC_ISSUE_DT Date(10) DATE NOT NULL Issue Date

Prompt Table: SFA_SLC_ACRDTVW

22 SFA_SLC_FILE_TYPE1 Character(3) VARCHAR2(3) NOT NULL File Type
ACR=Attendance Confirmation Reqst
EXT=Extended SISF
SCA=Short Course Attendance
SIS=Student Information Service
23 SFA_SLC_1ATT_CONF Character(1) VARCHAR2(1) NOT NULL Field to determine if the SSAC proces is confirming attendance for 1st liability.
24 SFA_SLC_LIAB_PRD Character(1) VARCHAR2(1) NOT NULL Liability Period
1=1
2=2
3=3

Default Value: 1

25 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
26 SFA_SLC_POP_SEL Character(1) VARCHAR2(1) NOT NULL Pop Select Checkbox for SLC
27 SFA_SLC_ADM_DT_OVR Date(10) DATE Admit Date Override