EMPLIDPrompt Table: PER_ORG_ASGN
EMPL_RCDPrompt Table: PER_ORG_ASGN
Prompt Table: LANGUAGE_CD_VW
PERORGASGBEL_CV(SQL View) |
Index Back |
|---|---|
PER_ORG_ASG_BEL MSG ClairviaClone of PER_ORG_ASG_BEL record for Clairvia Fullsync message |
| SELECT BEL.EMPLID , BEL.EMPL_RCD , BEL.OFFICIAL_LANG FROM PS_PER_ORG_ASG_BEL BEL , PS_PER_ORG_ASG_INT ASG WHERE ASG.EMPLID = BEL.EMPLID AND ASG.EMPL_RCD = BEL.EMPL_RCD AND ASG.INT_APP_TYPE = 'SCH' AND ASG.INTEGR_PROD_CD = 'CV' AND ASG.ENROLLED_FLAG = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PER_ORG_ASGN |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL |
Empl Record
Prompt Table: PER_ORG_ASGN |
| 3 | OFFICIAL_LANG | Character(3) | VARCHAR2(3) NOT NULL |
The Official Language is used by Belgium to track the official language for the company and employees. This language code indicates in which language the official reports and communication between company and employees should occur.
Prompt Table: LANGUAGE_CD_VW |