PROVINCEPrompt Table: PROVINCE_VW
CAN_PROV_FUND_CITZEFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
Default Value: CAN_PROV_CITZ.DESCR
CAN_PROV_CITZ(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 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 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 |