CBR_PERSON_AET

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

5 DEPENDENT_BENEF Character(2) VARCHAR2(2) NOT NULL Dependent Benefit
01=default

6 JOB_EMPL_RCD Number(3,0) SMALLINT NOT NULL employee employee record number

7 JOB_EFFDT Date(10) DATE Job Effective Date

8 JOB_EFFSEQ Number(3,0) SMALLINT NOT NULL Job Effective Sequence

9 COBRA_EMPLID Character(11) VARCHAR2(11) NOT NULL COBRA Generated Emplid

10 COBRA_EVENT_DT Date(10) DATE COBRA Event Date

11 CBR_NONEE_CREATE Character(1) VARCHAR2(1) NOT NULL COBRA non-employee
A=All (Both Personal and Job)
J=Job Information Only
P=Personal Information Only

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	DEPENDENT_BENEF	Character(2)	VARCHAR2(2) NOT NULL	Dependent Benefit 01=default
6	JOB_EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	employee employee record number
7	JOB_EFFDT	Date(10)	DATE	Job Effective Date
8	JOB_EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Job Effective Sequence
9	COBRA_EMPLID	Character(11)	VARCHAR2(11) NOT NULL	COBRA Generated Emplid
10	COBRA_EVENT_DT	Date(10)	DATE	COBRA Event Date
11	CBR_NONEE_CREATE	Character(1)	VARCHAR2(1) NOT NULL	COBRA non-employee A=All (Both Personal and Job) J=Job Information Only P=Personal Information Only