EMPLIDPrompt Table: PER_ORG_ASGN
EMPL_RCDPrompt Table: PER_ORG_ASGN
EFFDTEFFSEQHCR_ACTN_SEQNPER_OR_AS_B_STG(SQL Table) |
Index Back |
|---|---|
PER_ORG_ASG Ext for BrazilFluid Job - Staging Record - PER_ORG_ASG_BRA Contains fields for the country BRA. 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 | INS_DAYS_BRA | Character(2) | VARCHAR2(2) NOT NULL | INSS Days Brazil |
| 7 | INS_MONTHS_BRA | Character(2) | VARCHAR2(2) NOT NULL | INSS Months Brazil |
| 8 | INS_YEARS_BRA | Character(2) | VARCHAR2(2) NOT NULL | INSS Years Brazil |