CFX_DEPT (SQL Table)	Index Back
CF Export Process This table stores the chartfield values from lastest run of the CF Export Process. The process uses this table to only extract chartfields that have effectived dated changes.

CFX_DEPT

(SQL Table)

CF Export Process

This table stores the chartfield values from lastest run of the CF Export Process. The process uses this table to only extract chartfields that have effectived dated changes.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

3 EFFDT_FROM Date(10) DATE Effective Date From

4 EFFDT_TO Date(10) DATE Effective Date To

5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

6 DTTM_MODIFIED DateTime(26) TIMESTAMP Datetime modified

7 OPRID_LAST_UPDT Character(30) VARCHAR2(30) NOT NULL Last User to Update

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
3	EFFDT_FROM	Date(10)	DATE	Effective Date From
4	EFFDT_TO	Date(10)	DATE	Effective Date To
5	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
6	DTTM_MODIFIED	DateTime(26)	TIMESTAMP	Datetime modified
7	OPRID_LAST_UPDT	Character(30)	VARCHAR2(30) NOT NULL	Last User to Update
8	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance