EMPLIDPrompt Table: PERSON
ORG_INSTANCE_ERNPrompt Table: MIL_SERVICE_TBL
PER_ORG_INS_MIL(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 | 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. |
| 3 | MILITARY_SERVICE | Character(8) | VARCHAR2(8) NOT NULL |
Military Service
Prompt Table: MIL_SERVICE_TBL |