POSN_IDXCTL_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date
3	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
5	WF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Workflow Status A=Approved C=Cancelled D=Denied E=Error. Contact Administrator. F=Awaiting final approval I=In Approval Process M=Administrator is Processing N=Not Available P=Rework S=Submitted V=Data Saved
6	POSN_HEADCOUNT	Number(4,0)	SMALLINT NOT NULL	Position Headcount
7	MAX_HEAD_COUNT	Number(4,0)	SMALLINT NOT NULL	Max Head Count
8	CURR_HEAD_COUNT	Number(4,0)	SMALLINT NOT NULL	Current Head Count
9	POSN_DATA_MESSAGE	Character(1)	VARCHAR2(1) NOT NULL	Headcount Status F=Filled O=Open P=Partially Filled V=Overallocated
10	POSN_TOT_REP_INCUM	Number(8,0)	INTEGER NOT NULL	Incumbents in Reports To
11	POSITION_VACANT	Character(1)	VARCHAR2(1) NOT NULL	Position Vacant I=Not Applicable N=No Y=Yes
12	TOTAL_POSN_FTE	Number(13,2)	DECIMAL(12,2) NOT NULL	Total Position FTE
13	REPORTS_TO	Character(8)	VARCHAR2(8) NOT NULL	Reports To Position Number
14	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
15	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
16	INDEX_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Action for index D=Delete U=Insert/Update
17	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.
18	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time