PROVINCEPrompt Table: PROVINCE_VW
CAN_PROV_MAJOREFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
Default Value: CAN_PROV_MAJOR.DESCR
CAN_PROV_MAJOR(SQL Table) |
Index Back |
|---|---|
Prov Major CodeSac-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 | 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_MAJOR.DESCR |