EMPLIDPrompt Table: PERSON
EMPL_RCDDefault Value: 0
CWR=Contingent Worker
EMP=Employee
POI=Person of Interest
Default Value: PER_ORG_INST.PER_ORG
Default Value: PER_ORG_INST.ORG_INSTANCE_ERN
Prompt Table: PER_ORG_INST
HCR_PER_ORG_A_I(SQL View) |
Index Back |
|---|---|
Pers.Org Assignments Interf V.Personal Org Assignments Interface View |
| SELECT A.EMPLID , A.EMPL_RCD , A.PER_ORG , A.ORG_INSTANCE_ERN FROM PS_PER_ORG_ASGN A |
| # | 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
Default Value: 0 |
| 3 | PER_ORG | Character(3) | VARCHAR2(3) NOT NULL |
Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest.
CWR=Contingent Worker EMP=Employee POI=Person of Interest Default Value: PER_ORG_INST.PER_ORG |
| 4 | 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.
Default Value: PER_ORG_INST.ORG_INSTANCE_ERN Prompt Table: PER_ORG_INST |