| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSON
|
| 2 |
PUB_SVC_LNG_CAN |
Character(1) |
VARCHAR2(1) NOT NULL |
22 Dec. 1998 - S. Binpal
Language of service to the public. Added for Canada Official Languages Reporting Mods.
0=Not Applicable
1=English and French
2=English Only
3=French Only
Default Value: 0
|
| 3 |
INTRL_ON_LNG_CAN |
Character(1) |
VARCHAR2(1) NOT NULL |
22 Dec. 1998 - S. Binpal
Language of Internal service to Ontario North and East. Added for Canada Official Languages Reporting Mods.
0=Not Applicable
1=English and French
2=English Only
3=French Only
8=All Other Situations
Default Value: 0
|
| 4 |
INTRL_NCR_LNG_CAN |
Character(1) |
VARCHAR2(1) NOT NULL |
22 Dec. 1998 - S. Binpal
Language of internal service to NCR. (National Capital Region). Added for Canada Official Languages Reporting Mods.
0=Not Applicable
1=English and French
2=English Only
3=French Only
8=All Other Situations
Default Value: 0
|
| 5 |
INTRL_MNT_LNG_CAN |
Character(1) |
VARCHAR2(1) NOT NULL |
22 Dec. 1998 - S. Binpal
Language of internal service to Montreal. Added for Canada Official Languages Reporting Mods.
0=Not Applicable
1=English and French
2=English Only
3=French Only
8=All Other Situations
Default Value: 0
|
| 6 |
INTRL_QC_LNG_CAN |
Character(1) |
VARCHAR2(1) NOT NULL |
22 Dec. 1998 - S. Binpal
Language of internal service to Bilingual Quebec - Other. Added for Canada Official Languages Reporting Mods.
0=Not Applicable
1=English and French
2=English Only
3=French Only
8=All Other Situations
Default Value: 0
|
| 7 |
INTRL_NB_LNG_CAN |
Character(1) |
VARCHAR2(1) NOT NULL |
22 Dec. 1998 - S. Binpal
Language of internal service to New Brunswick. Added for Canada Official Languages Reporting Mods.
0=Not Applicable
1=English and French
2=English Only
3=French Only
8=All Other Situations
Default Value: 0
|
| 8 |
SUPR_COMM_ON_CAN |
Character(1) |
VARCHAR2(1) NOT NULL |
22 Dec. 1998 - S. Binpal
Communication requirements - Supervision to Ontario North and East. Added for Canada Official Languages Reporting Mods.
0=Not Applicable
1=Bilingual Supervision Required
8=All Other Situations
Default Value: 0
|
| 9 |
SUPR_COMM_NCR_CAN |
Character(1) |
VARCHAR2(1) NOT NULL |
22 Dec. 1998 - S. Binpal
Communication requirements - Supervision to NCR (National Capital Region). Added for Canada Official Languages Reporting Mods.
0=Not Applicable
1=Bilingual Supervision Required
8=All Other Situations
Default Value: 0
|
| 10 |
SUPR_COMM_QC_CAN |
Character(1) |
VARCHAR2(1) NOT NULL |
22 Dec. 1998 - S. Binpal
Communication requirements - Supervision to Bilingual Quebec - Other. Added for Canada Official Languages Reporting Mods.
0=Not Applicable
1=Bilingual Supervision Required
8=All Other Situations
Default Value: 0
|
| 11 |
SUPR_COMM_MNT_CAN |
Character(1) |
VARCHAR2(1) NOT NULL |
22 Dec. 1998 - S. Binpal
Communication requirements - Supervision to Montreal. Added for Canada Official Languages Reporting Mods.
0=Not Applicable
1=Bilingual Supervision Required
8=All Other Situations
Default Value: 0
|
| 12 |
SUPR_COMM_NB_CAN |
Character(1) |
VARCHAR2(1) NOT NULL |
22 Dec. 1998 - S. Binpal
Communication requirements - Supervision to New Brunswick. Added for Canada Official Languages Reporting Mods.
0=Not Applicable
1=Bilingual Supervision Required
8=All Other Situations
Default Value: 0
|