PROVINCEPrompt Table: PROVINCE_VW
CAN_PROV_FUND_CITZLANGUAGE_CDEFFDTDefault Value: %date
Default Value: CAN_PROV_CITZ.DESCR
CAN_PROV_CIT_LN(SQL Table) |
Index Back |
|---|---|
Province CitizenshipSac-r75-19990831 Prov Citizenship Fund Class. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROVINCE |
Character(6) | VARCHAR2(6) NOT NULL |
Province
Prompt Table: PROVINCE_VW |
| 2 | CAN_PROV_FUND_CITZ |
Character(6) | VARCHAR2(6) NOT NULL | Funding Class By Citiz Sac-r75-19990831: Classifies students by citizenship for grant purposes in accordance with the funding agency's policy. Leave this element blank if your institution does not report this information to the provincial ministry or other agency. |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL |
Short Description
Default Value: CAN_PROV_CITZ.DESCR |