FAN_INSTPCSL_VW(SQL View) |
Index Back |
|---|---|
Inst Parent CSL ViewSACE-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.PRT_RESIDENCE ,A.PRT_RSDNT_LENGTH ,A.MAR_STATUS ,A.NUM_DEPENDENTS ,A.NUM_COLLEGE ,A.FATHER_ID ,A.FATHER_NO_ID ,A.MOTHER_ID ,A.MOTHER_NO_ID ,A.FATHER_EARNINGS ,A.MOTHER_EARNINGS ,A.EXPECT_FATHER_EARN ,A.EXPECT_MOTHER_EARN ,A.PRT_INCOME_SRC ,A.FATHER_PENSION ,A.FATHER_EMPL_INS ,A.FATHER_TAX_PAID ,A.MOTHER_PENSION ,A.MOTHER_EMPL_INS ,A.MOTHER_TAX_PAID FROM PS_INST_PARENT_CSL A WHERE A.APP_SOURCE_CODE = '8' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 3 | AID_YEAR |
Character(4) | VARCHAR2(4) NOT NULL | Aid Year |
| 4 | PRT_RESIDENCE | Character(6) | VARCHAR2(6) NOT NULL |
Parent Residence
Prompt Table: PROVINCE_VW |
| 5 | PRT_RSDNT_LENGTH | Character(1) | VARCHAR2(1) NOT NULL |
Parent Residence Length
1=Less than 12 Months 2=At least 12 Months |
| 6 | MAR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Marital Status
C=Common-Law D=Divorced E=Separated H=Head of Household L=DissDeclLost Civil Partner M=Married P=Civil Partnership S=Single T=Surviving Civil Partner U=Unknown V=Dissolved Civil Partnership W=Widowed |
| 7 | NUM_DEPENDENTS | Number(2,0) | SMALLINT NOT NULL | Number of Dependents |
| 8 | NUM_COLLEGE | Number(2,0) | SMALLINT NOT NULL | Number in College |
| 9 | FATHER_ID | Character(9) | VARCHAR2(9) NOT NULL | Father's Social Insurance # |
| 10 | FATHER_NO_ID | Character(1) | VARCHAR2(1) NOT NULL |
Father has No ID
Y/N Table Edit |
| 11 | MOTHER_ID | Character(9) | VARCHAR2(9) NOT NULL | Mother's Social Insurance # |
| 12 | MOTHER_NO_ID | Character(1) | VARCHAR2(1) NOT NULL |
Mother has No ID
Y/N Table Edit |
| 13 | FATHER_EARNINGS | Number(8,0) | INTEGER NOT NULL | Father Actual Income |
| 14 | MOTHER_EARNINGS | Number(8,0) | INTEGER NOT NULL | Mother Actual Income |
| 15 | EXPECT_FATHER_EARN | Number(8,0) | INTEGER NOT NULL | Father Estimated Income |
| 16 | EXPECT_MOTHER_EARN | Number(8,0) | INTEGER NOT NULL | Mother Estimated Income |
| 17 | PRT_INCOME_SRC | Character(1) | VARCHAR2(1) NOT NULL |
Parent Income Source
1=Ontario Disability Program 2=Family Benefits 3=General Welfare 4=Other |
| 18 | FATHER_PENSION | Number(6,0) | INTEGER NOT NULL | Father's Pension |
| 19 | FATHER_EMPL_INS | Number(6,0) | INTEGER NOT NULL | Father's Empl Ins |
| 20 | FATHER_TAX_PAID | Number(6,0) | INTEGER NOT NULL | Father's Tax Paid |
| 21 | MOTHER_PENSION | Number(6,0) | INTEGER NOT NULL | Mother's Pension |
| 22 | MOTHER_EMPL_INS | Number(6,0) | INTEGER NOT NULL | Mother's Empl Ins |
| 23 | MOTHER_TAX_PAID | Number(6,0) | INTEGER NOT NULL | Mother's Tax Paid |