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 |