HR_FULLPART_DAT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
3	ACTION_DT_SS	Date(10)	DATE NOT NULL	Termination Date
4	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
5	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action Default Value: DTA Prompt Table: ACTION_TBL
6	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code
7	FULL_PART_TIME_NEW	Character(1)	VARCHAR2(1) NOT NULL	New Full/Part Time Status D=On Demand F=Full-Time P=Part-Time
8	POSITION_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Position Flag N=No Y=Yes
9	ORIGINATORID	Character(30)	VARCHAR2(30) NOT NULL	Originator Identifier
10	TRANSACTION_NAME	Character(25)	VARCHAR2(25) NOT NULL	EDI Transaction Name
11	UPD_BY_USERID	Character(30)	VARCHAR2(30) NOT NULL	Used on "_DAT" records for 8.3 Workflow Enhancements
12	UPD_DTTM	DateTime(26)	TIMESTAMP	Used on "_DAT" records for 8.3 Workflow Enhancements
13	MANUAL_UPD_USERID	Character(30)	VARCHAR2(30) NOT NULL	Used on "_DAT" records for 8.3 Workflow Enhancements
14	MANUAL_UPD_DTTM	DateTime(26)	TIMESTAMP	Used on "_DAT" records for 8.3 Workflow Enhancements
15	SS_STAT_INDICATOR	Character(1)	VARCHAR2(1) NOT NULL	Used on "_DAT" records for 8.3 Workflow Enhancements A=Approved B=CI failed - Errors & Warnings C=Cancelled D=Denied E=Errors Encountered I=In Approval Process M=Administrator Action Required S=Success W=Warnings Encountered Default Value: I
16	SS_WARNING_FLG	Character(1)	VARCHAR2(1) NOT NULL	Used on "_DAT" records for 8.3 Workflow Enhancements Y/N Table Edit Default Value: N
17	SS_FUTURE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Used on "_DAT" records for 8.3 Workflow Enhancements Y/N Table Edit Default Value: N