PROVINCEPrompt Table: PROVINCE_VW
CAN_PROV_SPEC_INITEFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
Default Value: CAN_PROV_SP_INT.DESCR
CAN_PROV_SP_INT(SQL Table) |
Index Back |
|---|---|
Prov Special Initiative CodeSac-r75-19990831 |
| # | 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 | 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_SP_INT.DESCR |