INST_STD_CSL_VW

(SQL View)
 Index Back

CSL Application view


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

  • 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: PEOPLE_SRCH

    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 APP_SOURCE_CODE Character(1) VARCHAR2(1) NOT NULL Application Source Code
    0=Need Access
    0=Need Access
    1=Electronic Initial Application
    2=Electronic Renewal Aplication
    3=Electronic Correction
    4=FAFSA Express
    5=ACT
    6=I-NET
    7=NCS
    8=Profile
    9=Institutional Application
    O=FT Canada Student Loan
    P=PT Canada Student Loan
    5 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    6 ORPHAN Character(1) VARCHAR2(1) NOT NULL Orphan or Ward of the Court
    1=Yes
    2=No
    N=No
    Y=Yes
    7 DEPENDENTS Character(1) VARCHAR2(1) NOT NULL Dependents Other Than Spouse
    1=Yes
    2=No
    N=No
    Y=Yes
    8 LAST_HS_DT Date(10) DATE Last High School Date
    9 PRIOR_POST_SEC Character(1) VARCHAR2(1) NOT NULL Prior Postsecondary Studies

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

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

    Prompt Table: PROVINCE_VW

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

    Prompt Table: PROVINCE_VW

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

    Y/N Table Edit

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

    Prompt Table: ACAD_PROG_TBL

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

    Y/N Table Edit

    35 HOUSING_CODE Character(1) VARCHAR2(1) NOT NULL Housing Code
    1=Campus Housing
    2=Off-Campus Housing
    3=With Parents
    4=With Relatives
    36 TRAVEL_HOME_COST Number(6,0) INTEGER NOT NULL Travel Home Cost
    37 STD_GROSS_INCOME Number(6,0) INTEGER NOT NULL Student Gross Income
    38 STD_INC_PRIOR_PS Number(13,3) DECIMAL(12,3) NOT NULL Std Inc Prior Ps
    39 STD_PS_INCOME Number(6,0) INTEGER NOT NULL Student Prestudy Income
    40 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
    41 BANKRUPTCY Character(1) VARCHAR2(1) NOT NULL Bankruptcy

    Y/N Table Edit

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

    Prompt Table: RELATIONSHIP_VW

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

    Prompt Table: RELATIONSHIP_VW

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

    Prompt Table: RELATIONSHIP_VW

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

    Prompt Table: RELATIONSHIP_VW

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

    Y/N Table Edit

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

    Y/N Table Edit

    68 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
    69 SPS_FT_COURSELOAD Character(1) VARCHAR2(1) NOT NULL Spouse FT Courseload

    Y/N Table Edit

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

    Y/N Table Edit

    71 SPS_INSTITUTION Character(25) VARCHAR2(25) NOT NULL Spouse Institution
    72 SPS_LAST_HS_DT Date(10) DATE Spouse Last High School Date
    73 SPS_GROSS_INC Number(6,0) INTEGER NOT NULL Spouse Gross Income
    74 SPS_INCOME_SRC Character(1) VARCHAR2(1) NOT NULL Spouse Income Source
    1=Ontario Disability Pgm
    2=Family Benefits
    3=General Welfare
    4=Other
    75 SPS_WKLY_HOURS Number(3,0) SMALLINT NOT NULL Spouse Weekly Hours
    76 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
    77 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
    78 PT_CHILD_CARE Number(4,0) SMALLINT NOT NULL PT Weekly Child Care
    79 PT_PRIOR_SOG Character(1) VARCHAR2(1) NOT NULL Prior SOG

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

    82 PT_RQSTD_CSL Character(5) VARCHAR2(5) NOT NULL Part-time Aid Requested
    83 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
    84 STD_WKLY_HOURS Number(3,0) SMALLINT NOT NULL Student Weekly Hours
    85 PRIOR_LOAN_PT Character(1) VARCHAR2(1) NOT NULL Prior Part-Time Loan
    86 PT_PRIOR_CSL_AMT Number(5,0) INTEGER NOT NULL Amt of Prior PT Loan
    87 LOAN_OVER_AWD Number(5,0) INTEGER NOT NULL Amount of Loan Overaward
    88 RESTRICTED_ELIG Character(1) VARCHAR2(1) NOT NULL Restricted Fed/Prov Elig
    89 AWARD_PERIOD Character(1) VARCHAR2(1) NOT NULL Award Period
    A=Academic
    N=Non Standard

    Default Value: A

    90 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. */
    91 CNAS_APPL_DATE Date(10) DATE CNAS Application Date