EMPLIDPrompt Table: PER_ORG_ASGN
EMPL_RCDPrompt Table: PER_ORG_ASGN
F=Family of Owner
L=Last Owner
PERORGASGNLD_CV(SQL View) |
Index Back |
|---|---|
PER_ORG_ASG_NLD MSG ClairviaClone of PER_ORG_ASG_NLD record for Clairvia Fullsync message |
| SELECT NLD.EMPLID , NLD.EMPL_RCD , NLD.RELAT_TO_OWNER_NLD FROM PS_PER_ORG_ASG_NLD NLD , PS_PER_ORG_ASG_INT ASG WHERE ASG.EMPLID = NLD.EMPLID AND ASG.EMPL_RCD = NLD.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 | RELAT_TO_OWNER_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Relation to Owner is used by the Netherlands to track whether an employee is either family of the owner or whether the employee was the last owner. This information is used for the Insurance Board Notification "Melding Bedrijfsvereniging".
F=Family of Owner L=Last Owner |