SACE-98D-NEW-FA05

CSL_CONTROL

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
2 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
3 NAME_MATCH Character(1) VARCHAR2(1) NOT NULL Name Match

Y/N Table Edit

Default Value: N

4 SIN_MATCH Character(1) VARCHAR2(1) NOT NULL SIN Match

Y/N Table Edit

Default Value: N

5 EMPLID_MATCH Character(1) VARCHAR2(1) NOT NULL ID Match

Y/N Table Edit

Default Value: N

6 FILE_PATH Character(127) VARCHAR2(127) NOT NULL Input/Output file path
7 ERR_FILE_PATH Character(127) VARCHAR2(127) NOT NULL Error file
8 OSAP_ADD_LEVEL Character(1) VARCHAR2(1) NOT NULL Record Add Level
0=Load Everyone
1=Recruits or Higher
2=Inactive Admits or Higher
3=Applicants or Higher
4=Active Admits or Higher
5=Accepted/Continuing Only

Default Value: 0

9 OSAP_SUSP_LEVEL Character(1) VARCHAR2(1) NOT NULL Record Suspend Level
0=Load Everyone
1=Recruits or Higher
2=Inactive Admits or Higher
3=Applicants or Higher
4=Active Admits or Higher
5=Accepted/Continuing Only

Default Value: 0

10 CSL_VAR Character(2) VARCHAR2(2) NOT NULL CSL Numeric Variable
1=Numeric Variable 1
10=Numeric Variable 10
2=Numeric Variable 2
3=Numeric Variable 3
4=Numeric Variable 4
5=Numeric Variable 5
6=Numeric Variable 6
7=Numeric Variable 7
8=Numeric Variable 8
9=Numeric Variable 9
11 OSL_VAR Character(2) VARCHAR2(2) NOT NULL Prov Loan Numeric Variable
1=Numeric Variable 1
10=Numeric Variable 10
2=Numeric Variable 2
3=Numeric Variable 3
4=Numeric Variable 4
5=Numeric Variable 5
6=Numeric Variable 6
7=Numeric Variable 7
8=Numeric Variable 8
9=Numeric Variable 9
12 CSG_VAR Character(2) VARCHAR2(2) NOT NULL CSG Numeric Variable
1=Numeric Variable 1
10=Numeric Variable 10
2=Numeric Variable 2
3=Numeric Variable 3
4=Numeric Variable 4
5=Numeric Variable 5
6=Numeric Variable 6
7=Numeric Variable 7
8=Numeric Variable 8
9=Numeric Variable 9