CBR_PER10_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	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.
4	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
5	POI_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines the Transactional usage of POIs in HRMS.
6	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.
7	ORIG_HIRE_DT	Date(10)	DATE	Original Start Date
8	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.
9	ORG_INST_SRV_DT	Date(10)	DATE	Org Instance Service Date
10	NEE_PROVIDER_ID	Character(10)	VARCHAR2(10) NOT NULL	The ID for the Non Employee Provider, Agency, or Employer.
11	COBRA_EVENT_ID	Number(3,0)	SMALLINT NOT NULL	Uniquely identifies a COBRA event within an employee's benefits records, and is system-generated.
12	BENEFIT_PROGRAM	Character(3)	VARCHAR2(3) NOT NULL	Defines a collection of benefit plans and their associated rate and calculation rules.