EMPLIDPrompt Table: PER_ORG_ASGN
EMPL_RCDPrompt Table: PER_ORG_ASGN
EFFDTEFFSEQHCR_ACTN_SEQNF=Family of Owner
L=Last Owner
PER_ORG_ASN_STG(SQL Table) |
Index Back |
|---|---|
PER_ORG- Exts for NetherlandsFluid Job - Staging Record - PER_ORG_ASG_NLD Contains fields for the country NLD This record will be a child to PER_ORG_ASGN in the Component Processor - but the real relationship to PER_ORG_ASGN is Zero to One. |
| # | 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 | EFFDT |
Date(10) | DATE | Effective Date |
| 4 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | HCR_ACTN_SEQN |
Number(3,0) | SMALLINT NOT NULL | Sequence number |
| 6 | 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 |