PROVINCEPrompt Table: PROVINCE_VW
CAN_PROV_MAJORLANGUAGE_CDEFFDTDefault Value: %date
Default Value: CAN_PROV_MAJOR.DESCR
CAN_PROV_MJR_LN(SQL Table) |
Index Back |
|---|---|
CAN_PROV_MAJOR Related LanguagSac-r75-1990831 |
| # | 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_MAJOR |
Character(8) | VARCHAR2(8) NOT NULL | Sac-r75-1990831: The field of study code assigned by the provincial ministry or other administrative body to identify the program. 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_MAJOR.DESCR |