FAN_INSTSCSL_VW

(SQL View)
 Index Back

Inst Student CSL View

SACE-98D NEW -FA05 This is a view of this table used for Fin Aid Award Notification Letter equation selection processing.

SELECT A.EMPLID ,A.INSTITUTION ,A.AID_YEAR ,A.CURRENCY_CD ,A.ORPHAN ,A.DEPENDENTS ,A.LAST_HS_DT ,A.PRIOR_POST_SEC ,A.PRIOR_POST_SEC_DT ,A.PRIOR_LOAN ,A.DEFAULTED_LOAN ,A.OUT_HS_YRS ,A.IN_WORKFORCE ,A.STD_RESIDENCE ,A.SPS_RESIDENCE ,A.STD_RSDNT_LENGTH ,A.SPS_RSDNT_LENGTH ,A.CITIZENSHIP_CSL ,A.ACAD_PROG_ANTIC ,A.SP_START_DT ,A.SP_END_DT ,A.DEGREE_CSL ,A.YEAR_IN_PROGRAM ,A.TOTAL_PGM_YEARS ,A.COOP_PROGRAM ,A.SP_CRSE_LD_PCT ,A.NUM_TERMS ,A.FED_YEAR_COA ,A.INST_YEAR_COA ,A.TUIT_COMPONENT ,A.REG_PROGRAM ,A.FA_NUMBER_OF_WEEKS ,A.CORRESP_DIST_ED ,A.HOUSING_CODE ,A.TRAVEL_HOME_COST ,A.STD_GROSS_INCOME ,A.STD_INC_PRIOR_PS ,A.STD_PS_INCOME ,A.STD_PS_INCOME_SRC ,A.BANKRUPTCY ,A.HOUSING_CODE_PS ,A.STD_SP_GROSS_INC ,A.STD_SP_OTH_INCOME ,A.STD_SP_INC_SRC ,A.HOUSING_CODE_SP ,A.VEHICLE_MAKE_1 ,A.VEHICLE_MODEL_1 ,A.VEHICLE_YEAR_1 ,A.VEHICLE_VALUE_1 ,A.VEHICLE_MAKE_2 ,A.VEHICLE_MODEL_2 ,A.VEHICLE_YEAR_2 ,A.VEHICLE_VALUE_2 ,A.RETRMNT_SAV_VALUE ,A.INVESTMENT_VALUE ,A.NUM_DEP_GROUP1 ,A.NUM_DEP_GROUP2 ,A.NUM_DEP_GROUP3 ,A.CHILD_CARE_COSTS ,A.CSL_NEXT_OF_KIN ,A.RELEASE_TO_1 ,A.RELEASE_TO_2 ,A.SPOUSE ,A.SPOUSE_ID ,A.SPOUSE_NO_ID ,A.SPS_CAN_RES ,A.SPS_OCCUPATION ,A.SPS_FT_COURSELOAD ,A.SPS_12WK_PGM ,A.SPS_INSTITUTION ,A.SPS_LAST_HS_DT ,A.SPS_GROSS_INC ,A.SPS_INCOME_SRC ,A.SPS_WKLY_HOURS ,A.PT_STD_STATUS ,A.PART_TIME_REASON ,A.PT_CHILD_CARE ,A.PT_PRIOR_SOG ,A.PT_SAT_PGRS ,A.PT_CALC_SOG ,A.PT_RQSTD_CSL ,A.STD_OCCUPATION ,A.STD_WKLY_HOURS ,A.PRIOR_LOAN_PT ,A.PT_PRIOR_CSL_AMT ,A.LOAN_OVER_AWD ,A.RESTRICTED_ELIG ,A.AWARD_PERIOD ,A.MAR_STATUS_DT ,A.CNAS_APPL_DATE ,A.MERIT_SCHOL_RECIP ,A.STD_SP_INC_SRC_01 ,A.STD_SP_S_B_A_INC FROM PS_INST_STDNT_CSL A WHERE A.APP_SOURCE_CODE = '8'

  • Parent record: STUDENT_AID

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSONAL_DATA

    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    3 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

    Prompt Table: STUDENT_AID

    4 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    5 ORPHAN Character(1) VARCHAR2(1) NOT NULL Orphan or Ward of the Court
    1=Yes
    2=No
    N=No
    Y=Yes
    6 DEPENDENTS Character(1) VARCHAR2(1) NOT NULL Dependents Other Than Spouse
    1=Yes
    2=No
    N=No
    Y=Yes
    7 LAST_HS_DT Date(10) DATE Last High School Date
    8 PRIOR_POST_SEC Character(1) VARCHAR2(1) NOT NULL Prior Postsecondary Studies

    Y/N Table Edit

    9 PRIOR_POST_SEC_DT Date(10) DATE Prior Post Sec Date
    10 PRIOR_LOAN Character(1) VARCHAR2(1) NOT NULL Prior Canadian Student Loan

    Y/N Table Edit

    11 DEFAULTED_LOAN Character(1) VARCHAR2(1) NOT NULL Defaulted Loan

    Y/N Table Edit

    12 OUT_HS_YRS Number(2,0) SMALLINT NOT NULL Years Out of High School
    13 IN_WORKFORCE Character(1) VARCHAR2(1) NOT NULL In Workforce

    Y/N Table Edit

    14 STD_RESIDENCE Character(6) VARCHAR2(6) NOT NULL Student's Residence

    Prompt Table: PROVINCE_VW

    15 SPS_RESIDENCE Character(6) VARCHAR2(6) NOT NULL Spouse's Residence

    Prompt Table: PROVINCE_VW

    16 STD_RSDNT_LENGTH Character(1) VARCHAR2(1) NOT NULL Student's Residence Length
    1=Less than 12 Months
    2=At least 12 Months
    17 SPS_RSDNT_LENGTH Character(1) VARCHAR2(1) NOT NULL Spouse's Residence Length
    1=Less than 12 Months
    2=At least 12 Months
    18 CITIZENSHIP_CSL Character(1) VARCHAR2(1) NOT NULL CSL Citizenship

    Y/N Table Edit

    19 ACAD_PROG_ANTIC Character(5) VARCHAR2(5) NOT NULL Anticipated Academic Program

    Prompt Table: ACAD_PROG_TBL

    20 SP_START_DT Date(10) DATE Study Period Start Date
    21 SP_END_DT Date(10) DATE Study Period End Date
    22 DEGREE_CSL Character(1) VARCHAR2(1) NOT NULL Degree/Certificate
    1=Diploma
    2=Certificate
    3=Bachelor's Degree
    4=Master's Degee
    5=Doctoral Degree
    23 YEAR_IN_PROGRAM Character(2) VARCHAR2(2) NOT NULL Year in Program
    24 TOTAL_PGM_YEARS Character(2) VARCHAR2(2) NOT NULL Total Program Years
    25 COOP_PROGRAM Character(1) VARCHAR2(1) NOT NULL Co-op Program
    C=Co-op Program
    N=Not in Co-op Program
    26 SP_CRSE_LD_PCT Number(6,2) DECIMAL(5,2) NOT NULL Anticipated Course Load Pct
    27 NUM_TERMS Number(1,0) SMALLINT NOT NULL Number of Terms
    28 FED_YEAR_COA Number(9,2) DECIMAL(8,2) NOT NULL Fed Year COA
    29 INST_YEAR_COA Number(9,2) DECIMAL(8,2) NOT NULL Inst Year COA
    30 TUIT_COMPONENT Number(5,0) INTEGER NOT NULL Tuition and Fees Component
    31 REG_PROGRAM Character(1) VARCHAR2(1) NOT NULL Regulated Program
    N=Non-Regulated Program
    R=Regulated Program
    32 FA_NUMBER_OF_WEEKS Number(3,0) SMALLINT NOT NULL FA Number of Weeks
    33 CORRESP_DIST_ED Character(1) VARCHAR2(1) NOT NULL Correspondence/Distance Ed

    Y/N Table Edit

    34 HOUSING_CODE Character(1) VARCHAR2(1) NOT NULL Housing Code
    1=Campus Housing
    2=Off-Campus Housing
    3=With Parents
    4=With Relatives
    35 TRAVEL_HOME_COST Number(6,0) INTEGER NOT NULL Travel Home Cost
    36 STD_GROSS_INCOME Number(6,0) INTEGER NOT NULL Student Gross Income
    37 STD_INC_PRIOR_PS Number(13,3) DECIMAL(12,3) NOT NULL Std Inc Prior Ps
    38 STD_PS_INCOME Number(6,0) INTEGER NOT NULL Student Prestudy Income
    39 STD_PS_INCOME_SRC Character(1) VARCHAR2(1) NOT NULL Student Prestudy Income Source
    1=Ontario Disability Pgm
    2=Family Benefits
    3=General Welfare
    4=Other
    40 BANKRUPTCY Character(1) VARCHAR2(1) NOT NULL Bankruptcy

    Y/N Table Edit

    41 HOUSING_CODE_PS Character(1) VARCHAR2(1) NOT NULL Prestudy Housing
    O=Other
    P=With Parents
    42 STD_SP_GROSS_INC Number(6,0) INTEGER NOT NULL Student Study Pd Gross Income
    43 STD_SP_OTH_INCOME Number(6,0) INTEGER NOT NULL Student Study Pd Other Income
    44 STD_SP_INC_SRC Character(1) VARCHAR2(1) NOT NULL Student Study Pd Income Source
    1=Ontario Disability Pgm
    2=Family Benefits
    3=General Welfare
    4=Other
    45 HOUSING_CODE_SP Character(1) VARCHAR2(1) NOT NULL Study Period Housing
    O=Other
    P=With Parents
    46 VEHICLE_MAKE_1 Character(25) VARCHAR2(25) NOT NULL Vehicle Make 1
    47 VEHICLE_MODEL_1 Character(25) VARCHAR2(25) NOT NULL Vehicle Model 1
    48 VEHICLE_YEAR_1 Character(4) VARCHAR2(4) NOT NULL Vehicle Year 1
    49 VEHICLE_VALUE_1 Number(5,0) INTEGER NOT NULL Vehicle Value 1
    50 VEHICLE_MAKE_2 Character(25) VARCHAR2(25) NOT NULL Vehicle Make 2
    51 VEHICLE_MODEL_2 Character(25) VARCHAR2(25) NOT NULL Vehicle Model 2
    52 VEHICLE_YEAR_2 Character(4) VARCHAR2(4) NOT NULL Vehicle Year 2
    53 VEHICLE_VALUE_2 Number(5,0) INTEGER NOT NULL Vehicle Value 2
    54 RETRMNT_SAV_VALUE Number(8,0) INTEGER NOT NULL Retirement Savings Value
    55 INVESTMENT_VALUE Number(8,0) INTEGER NOT NULL Investment Value
    56 NUM_DEP_GROUP1 Number(2,0) SMALLINT NOT NULL Dependents 11 and Under
    57 NUM_DEP_GROUP2 Number(2,0) SMALLINT NOT NULL Dependents 12 to 18
    58 NUM_DEP_GROUP3 Number(2,0) SMALLINT NOT NULL Dependents 19 and Older
    59 CHILD_CARE_COSTS Number(5,0) INTEGER NOT NULL Child Care Costs
    60 CSL_NEXT_OF_KIN Number(2,0) SMALLINT NOT NULL Next of Kin

    Prompt Table: RELATIONSHIP_VW

    61 RELEASE_TO_1 Number(2,0) SMALLINT NOT NULL Release To 1

    Prompt Table: RELATIONSHIP_VW

    62 RELEASE_TO_2 Number(2,0) SMALLINT NOT NULL Release To 2

    Prompt Table: RELATIONSHIP_VW

    63 SPOUSE Number(2,0) SMALLINT NOT NULL Spouse

    Prompt Table: RELATIONSHIP_VW

    64 SPOUSE_ID Character(11) VARCHAR2(11) NOT NULL Spouse ID
    65 SPOUSE_NO_ID Character(1) VARCHAR2(1) NOT NULL Spouse has No ID

    Y/N Table Edit

    66 SPS_CAN_RES Character(1) VARCHAR2(1) NOT NULL Living in Canada

    Y/N Table Edit

    67 SPS_OCCUPATION Character(1) VARCHAR2(1) NOT NULL Spouse's Occupation
    1=Full-time Student
    2=Employed, full-time
    3=Employed, part-time
    4=Unemployed
    5=Other
    68 SPS_FT_COURSELOAD Character(1) VARCHAR2(1) NOT NULL Spouse FT Courseload

    Y/N Table Edit

    69 SPS_12WK_PGM Character(1) VARCHAR2(1) NOT NULL Spouse 12Wk PGm

    Y/N Table Edit

    70 SPS_INSTITUTION Character(25) VARCHAR2(25) NOT NULL Spouse Institution
    71 SPS_LAST_HS_DT Date(10) DATE Spouse Last High School Date
    72 SPS_GROSS_INC Number(6,0) INTEGER NOT NULL Spouse Gross Income
    73 SPS_INCOME_SRC Character(1) VARCHAR2(1) NOT NULL Spouse Income Source
    1=Ontario Disability Pgm
    2=Family Benefits
    3=General Welfare
    4=Other
    74 SPS_WKLY_HOURS Number(3,0) SMALLINT NOT NULL Spouse Weekly Hours
    75 PT_STD_STATUS Character(1) VARCHAR2(1) NOT NULL Part-Time Student Status
    1=Full-time Student
    2=Employed, full-time
    3=Employed, part-time
    4=Unemployed
    5=Other
    76 PART_TIME_REASON Character(1) VARCHAR2(1) NOT NULL Part-time Reason
    1=Single Parent
    2=Elderly Dependents
    3=Restricted Mature Student
    4=Disabled
    5=Grade Improvement
    6=Excessive Debt
    7=Financial
    8=Courses Not Available
    9=Program Almost Complete
    O=Other
    77 PT_CHILD_CARE Number(4,0) SMALLINT NOT NULL PT Weekly Child Care
    78 PT_PRIOR_SOG Character(1) VARCHAR2(1) NOT NULL Prior SOG

    Y/N Table Edit

    79 PT_SAT_PGRS Character(1) VARCHAR2(1) NOT NULL SAP for previous SOG

    Y/N Table Edit

    80 PT_CALC_SOG Character(1) VARCHAR2(1) NOT NULL Perform SOG Grant Calc

    Y/N Table Edit

    81 PT_RQSTD_CSL Character(5) VARCHAR2(5) NOT NULL Part-time Aid Requested
    82 STD_OCCUPATION Character(1) VARCHAR2(1) NOT NULL Student's Occupation
    1=Full-time Student
    2=Employed, full-time
    3=Employed, part-time
    4=Unemployed
    5=Other
    83 STD_WKLY_HOURS Number(3,0) SMALLINT NOT NULL Student Weekly Hours
    84 PRIOR_LOAN_PT Character(1) VARCHAR2(1) NOT NULL Prior Part-Time Loan
    85 PT_PRIOR_CSL_AMT Number(5,0) INTEGER NOT NULL Amt of Prior PT Loan
    86 LOAN_OVER_AWD Number(5,0) INTEGER NOT NULL Amount of Loan Overaward
    87 RESTRICTED_ELIG Character(1) VARCHAR2(1) NOT NULL Restricted Fed/Prov Elig
    88 AWARD_PERIOD Character(1) VARCHAR2(1) NOT NULL Award Period
    A=Academic
    N=Non Standard
    89 MAR_STATUS_DT Date(10) DATE This is the date that the employee's Marital status is/was effective. /* Marital Status date is stored redundantly on PERS_DATA_EFFDT for two reasons. 1. To allow the date to be entered prior to the first PERS_DATA_EFFDT so that the actual date for the marital status on the hire row can be entered. This is the only time that the field is enterable by the user. 2. To allow for easier reporting on the data via SQR and Crystal. This is denormalizing the PERS_DATA_EFFDT record, but the number of requests for this redundancy coupled with the need for #1, has provided the justification for denormalizing this information and taking on the added maintenance. */
    90 CNAS_APPL_DATE Date(10) DATE CNAS Application Date
    91 MERIT_SCHOL_RECIP Character(1) VARCHAR2(1) NOT NULL Merit Scholarship Recipient

    Y/N Table Edit

    92 STD_SP_INC_SRC_01 Character(1) VARCHAR2(1) NOT NULL Student Study Pd Income Source
    1=Employment Insurance
    2=Loss of Earnings Benefits
    3=Extended Care & Maint Alwnc
    4=Ontario Disability Support Pgm
    5=Ontario Works
    6=Family Benefits
    7=Natv Post-Sec Stu Sup Pgm
    8=Canada Pension Plan
    9=Other
    93 STD_SP_S_B_A_INC Number(6,0) INTEGER NOT NULL Student Study Pd S/B/A Income