EMPLIDPrompt Table: PERSON
EMPL_RCDEFFDTDefault Value: %date
EFFSEQHCR_ACTN_SEQNORG_INSTANCE_ERNPrompt Table: MIL_SERVICE_TBL
PR_OR_IN_ML_STG(SQL Table) |
Index Back |
|---|---|
Person Org Inst. - MilitaryPerson Org Instsance - Military |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | HCR_ACTN_SEQN |
Number(3,0) | SMALLINT NOT NULL | Sequence number |
| 6 | ORG_INSTANCE_ERN |
Number(3,0) | SMALLINT NOT NULL | Indicates which EMPL_RCD (ERN) is considered the Organizational Instance for this particular ERN. An Organizational Instance defines an Instance of Employment or an Instance of Contingent Workforce. Hire, Termination, and Service dates are captured at the Organiational Instance level. |
| 7 | MILITARY_SERVICE | Character(8) | VARCHAR2(8) NOT NULL |
Military Service
Prompt Table: MIL_SERVICE_TBL |