PER_ORG_INS_STG (SQL Table)	Index Back
Person Org Instance Fluid Job - Staging Record - PER_ORG_INST Contains the Organizational Relationship / EMPL_RCD association(s) for a Person's PER_ORG where this represents a separate Organizational instance with the customer's organization. IE a separate employment instance where we need to capture Hire dates.

PER_ORG_INS_STG

(SQL Table)

Person Org Instance

Fluid Job - Staging Record - PER_ORG_INST Contains the Organizational Relationship / EMPL_RCD association(s) for a Person's PER_ORG where this represents a separate Organizational instance with the customer's organization. IE a separate employment instance where we need to capture Hire dates.

# 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

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 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

8 POI_TYPE Character(5) VARCHAR2(5) NOT NULL Defines the Transactional usage of POIs in HRMS.
Prompt Table: POI_TYPE_TBL

9 ORIG_HIRE_OVR Character(1) VARCHAR2(1) NOT NULL Used to indicate whether the user has overridden the Original Hire Date. If they have, then the field will not be set by the JOB peoplecode.
Y/N Table Edit
Default Value: N

10 ORIG_HIRE_DT Date(10) DATE Original Start Date

11 ORG_INST_SRV_OVR Character(1) VARCHAR2(1) NOT NULL Used to indicate whether the user has overridden the Organizational Instance Service Date If they have, then the field will not be set by the JOB peoplecode.
Y/N Table Edit
Default Value: N

12 ORG_INST_SRV_DT Date(10) DATE Org Instance Service Date

13 NEE_PROVIDER_ID Character(10) VARCHAR2(10) NOT NULL The ID for the Non Employee Provider, Agency, or Employer.
Prompt Table: NEE_PROVIDR_TBL

14 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

15 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	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
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	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
8	POI_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines the Transactional usage of POIs in HRMS. Prompt Table: POI_TYPE_TBL
9	ORIG_HIRE_OVR	Character(1)	VARCHAR2(1) NOT NULL	Used to indicate whether the user has overridden the Original Hire Date. If they have, then the field will not be set by the JOB peoplecode. Y/N Table Edit Default Value: N
10	ORIG_HIRE_DT	Date(10)	DATE	Original Start Date
11	ORG_INST_SRV_OVR	Character(1)	VARCHAR2(1) NOT NULL	Used to indicate whether the user has overridden the Organizational Instance Service Date If they have, then the field will not be set by the JOB peoplecode. Y/N Table Edit Default Value: N
12	ORG_INST_SRV_DT	Date(10)	DATE	Org Instance Service Date
13	NEE_PROVIDER_ID	Character(10)	VARCHAR2(10) NOT NULL	The ID for the Non Employee Provider, Agency, or Employer. Prompt Table: NEE_PROVIDR_TBL
14	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
15	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.