PROVINCEPrompt Table: PROVINCE_VW
CAN_PROV_SPEC_INITLANGUAGE_CDEFFDTDefault Value: %date
Default Value: CAN_PROV_SP_INT.DESCR
CAN_PRV_SPIN_LN(SQL Table) |
Index Back |
|---|---|
CAN_PROV_SP_INT Related Lang.Sac-r75-19990831 Related Language for Prov Special Initiative Code. |
| # | 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_SPEC_INIT |
Character(6) | VARCHAR2(6) NOT NULL | Special Initiative Sac-r75-19990831: The Special initiative code associated with the student in the program, as specified by the provincial ministry, institution or other agency. If no codeset is specified by the provincial ministry or other agency and the institution does not record Special initiative codes, leave this element blank. |
| 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_SP_INT.DESCR |