| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table:
INSTITUTION_TBL
|
| 2 |
AID_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Aid Year
Default Value: OPR_DEF_TBL_CS.AID_YEAR
Prompt Table:
AID_YEAR_TBL
|
| 3 |
CNAS_RULE_SET |
Character(4) |
VARCHAR2(4) NOT NULL |
CNAS Rule Set
1=Temp Value 1
2=Temp Value 2
C=CSL Rule Set
Prompt Table:
CNAS_SETUP_TBL
|
| 4 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 5 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
| 6 |
CSL_OSL |
Character(1) |
VARCHAR2(1) NOT NULL |
CSL-OSL
C=CSL
O=OSL
|
| 7 |
REQ_HS_YRS |
Number(1,0) |
SMALLINT NOT NULL |
Required High School Years
|
| 8 |
INST_PROVINCE |
Character(6) |
VARCHAR2(6) NOT NULL |
Institution Province
Prompt Table:
PROVINCE_VW
|
| 9 |
REQ_RSDNT_LENGTH |
Character(1) |
VARCHAR2(1) NOT NULL |
Required Residence Length
1=Less than 12 Months
2=At least 12 Months
|
| 10 |
WORKFORCE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Workforce Option
Y/N Table Edit
|
| 11 |
COMMONLAW_YEARS |
Number(2,0) |
SMALLINT NOT NULL |
Common-law Years
|
| 12 |
USE_COA |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Cost of Attendance
F=Fed Year COA
I=Inst Year COA
|
| 13 |
USE_CAPS |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Caps
Y/N Table Edit
|
| 14 |
FM_IM_USE |
Character(1) |
VARCHAR2(1) NOT NULL |
FM/IM Use
B=Both FM and IM EFC
F=FM EFC
I=IM EFC
|
| 15 |
PS_CONTR_RATE |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Prestudy Contribution Rate
Default Value: 80
|
| 16 |
PS_SPS_RATE |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Prestudy Spouse Percent
|
| 17 |
PS_INC_ALLOW |
Number(5,0) |
INTEGER NOT NULL |
Prestudy Allow Against Minimum
|
| 18 |
PS_INC_ALLOW2 |
Number(5,0) |
INTEGER NOT NULL |
Prestudy Allow Against Actual
|
| 19 |
SP_STD_CONTR_RATE |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Study Period Contribution Rt
|
| 20 |
SP_GOVT_RATE |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Study Pd Govt Cont Rate
|
| 21 |
SP_SPS_RATE |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Study Period Spouse Percent
|
| 22 |
SP_ALLOW |
Number(5,0) |
INTEGER NOT NULL |
Study Pd Allow Against Inc
|
| 23 |
SP_ALLOW_GOVT |
Number(5,0) |
INTEGER NOT NULL |
Study Pd Govt Ben Allow
|
| 24 |
RRSP_YRLY_ADJ |
Number(5,0) |
INTEGER NOT NULL |
RRSP Yearly Adjustment
|
| 25 |
DISABILITY1 |
Number(5,0) |
INTEGER NOT NULL |
Disability Exemption 1
|
| 26 |
DISABILITY2 |
Number(5,0) |
INTEGER NOT NULL |
Disability Exemption 2
|
| 27 |
DISABILITY3 |
Number(5,0) |
INTEGER NOT NULL |
Disability Exemption 3
|
| 28 |
CAR_ALLOW |
Number(5,0) |
INTEGER NOT NULL |
Car Allowance
|
| 29 |
ASSET_ALLOW |
Number(5,0) |
INTEGER NOT NULL |
Asset Allowance
|
| 30 |
ASSET_SC_RATE |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Asset Contribution Rate
|
| 31 |
PRT_CPP_MAX |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Parent CPP Maximum
|
| 32 |
PRT_EMP_INS_MAX |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Parent Max Employment Ins
|
| 33 |
PRT_INC_ALLOW |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Parent Income Allowance
|
| 34 |
PRT_SPCL_PC_CALC |
Character(1) |
VARCHAR2(1) NOT NULL |
Parent Calc PC w/Table E
|
| 35 |
PS_MAX_WKS |
Number(2,0) |
SMALLINT NOT NULL |
Prestudy Maximum Weeks
|
| 36 |
PS_MIN_WKS |
Number(2,0) |
SMALLINT NOT NULL |
Prestudy Minimum Weeks
|
| 37 |
PS_MIN_SC |
Number(5,0) |
INTEGER NOT NULL |
Prestudy Minimum Contribution
|
| 38 |
PT_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Part-time Percent
|
| 39 |
PT_DSBLD_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Part-time Disabled Pct
|
| 40 |
AWD_PER_USE |
Character(1) |
VARCHAR2(1) NOT NULL |
Award Period Use
A=Academic
B=Both
N=Non-Standard
|
| 41 |
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
|
| 42 |
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
|
| 43 |
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
|
| 44 |
PT_LOAN_MIN_AMT |
Number(5,0) |
INTEGER NOT NULL |
Part-Time Loan Minimum Amount
|
| 45 |
FT_LOAN_MIN_AMT |
Number(5,0) |
INTEGER NOT NULL |
Full-Time Loan Minimum Amount
|
| 46 |
SP_ALLOW_MERIT |
Number(5,0) |
INTEGER NOT NULL |
Study Pd Allow - Merit
|
| 47 |
SP_ALLOW_NON_MERIT |
Number(5,0) |
INTEGER NOT NULL |
Study Pd Allow - Non-Merit
|
| 48 |
SP_SPS_1INCOL_RATE |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Study Pd Spouse 1 in Col Pct
|
| 49 |
SP_SPS_2INCOL_RATE |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Study Pd Spouse 2 in Col Pct
|