POSITION_CH_DAT (SQL Table)	Index Back
Tranaction Summary Record Tranaction Summary Record Created to have the Summary Page

POSITION_CH_DAT

(SQL Table)

Tranaction Summary Record

Tranaction Summary Record Created to have the Summary Page

Related Language Record: POSITION_CH_LNG

# 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 Effective Date
Default Value: %date

3 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

4 POS_LABEL_ID Character(30) VARCHAR2(30) NOT NULL Label ID

5 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description

6 OLDVALUE Character(65) VARCHAR2(65) NOT NULL Old Value

7 NEWVALUE Character(65) VARCHAR2(65) NOT NULL New Value

8 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

9 POS_TRANSACTION Character(30) VARCHAR2(30) NOT NULL To identify the position transaction

#	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	Effective Date Default Value: %date
3	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
4	POS_LABEL_ID	Character(30)	VARCHAR2(30) NOT NULL	Label ID
5	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description
6	OLDVALUE	Character(65)	VARCHAR2(65) NOT NULL	Old Value
7	NEWVALUE	Character(65)	VARCHAR2(65) NOT NULL	New Value
8	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
9	POS_TRANSACTION	Character(30)	VARCHAR2(30) NOT NULL	To identify the position transaction