PV_VER_UPD_STG (SQL Table)	Index Back
Online Updates Staging

PV_VER_UPD_STG

(SQL Table)

Online Updates Staging

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

3 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag
Y/N Table Edit

4 ITM_STATUS_CURRENT Character(1) VARCHAR2(1) NOT NULL Item Status Current
1=Active
2=Hold
3=Discontinue
4=Inactive
5=Pending Approval
6=Denied Approval
7=Under Initialization

5 ITM_STATUS_FUTURE Character(1) VARCHAR2(1) NOT NULL Item Status Future
1=Active
2=Hold
3=Discontinue
4=Inactive

6 LAST_DTTM_UPDATE 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
3	IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	In process flag Y/N Table Edit
4	ITM_STATUS_CURRENT	Character(1)	VARCHAR2(1) NOT NULL	Item Status Current 1=Active 2=Hold 3=Discontinue 4=Inactive 5=Pending Approval 6=Denied Approval 7=Under Initialization
5	ITM_STATUS_FUTURE	Character(1)	VARCHAR2(1) NOT NULL	Item Status Future 1=Active 2=Hold 3=Discontinue 4=Inactive
6	LAST_DTTM_UPDATE	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.