SACE-98D NEW -FA05

CNAS_OPT_COPY

(SQL View)
 Index Back

SELECT A.INSTITUTION, A.AID_YEAR, A.CNAS_RULE_SET, A.DESCR, A.DESCRSHORT, A.CSL_OSL, A.REQ_HS_YRS, A.INST_PROVINCE, A.REQ_RSDNT_LENGTH, A.WORKFORCE_OPT, A.COMMONLAW_YEARS, A.USE_COA, A.USE_CAPS, A.FM_IM_USE, A.PS_CONTR_RATE, A.PS_SPS_RATE, A.PS_INC_ALLOW, A.PS_INC_ALLOW2, A.SP_STD_CONTR_RATE, A.SP_GOVT_RATE, A.SP_SPS_RATE, A.SP_ALLOW, A.SP_ALLOW_GOVT, A.RRSP_YRLY_ADJ, A.DISABILITY1, A.DISABILITY2, A.DISABILITY3, A.CAR_ALLOW, A.ASSET_ALLOW, A.ASSET_SC_RATE, A.PRT_CPP_MAX, A.PRT_EMP_INS_MAX, A.PRT_INC_ALLOW, A.PRT_SPCL_PC_CALC, A.PS_MAX_WKS,A.PS_MIN_WKS, A.PS_MIN_SC, A.PT_PCT, A.PT_DSBLD_PCT, A.AWD_PER_USE, A.OSL_VAR, A.CSL_VAR, A.CSG_VAR, A.PT_LOAN_MIN_AMT, A.FT_LOAN_MIN_AMT, A.SP_ALLOW_MERIT, A.SP_ALLOW_NON_MERIT, A.SP_SPS_1INCOL_RATE, A.SP_SPS_2INCOL_RATE FROM PS_CNAS_OPTION_TBL A

  • Related Language Record: CNASOPTCOPYLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    2 AID_YEAR Character(4) VARCHAR2(4) NOT NULL 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