EOEP_KVCNT_EC (SQL Table)	Index Back
Price Key Val. Count Stg Tbl Price Key Value Count Staging Table

EOEP_KVCNT_EC

(SQL Table)

Price Key Val. Count Stg Tbl

Price Key Value Count Staging Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field

2 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values

3 PPRC_KEY_VALUE1 Character(60) VARCHAR2(60) NOT NULL Price Key value 1

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

5 TOTAL_COUNT Number(7,0) INTEGER NOT NULL Total Count

6 PUBNODE Character(30) VARCHAR2(30) NOT NULL Application Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.

7 MSGNAME Character(30) VARCHAR2(30) NOT NULL Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).

8 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag

9 FULL_SYNC_FLG Character(1) VARCHAR2(1) NOT NULL Full Sync Indicator.

10 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.

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

12 EIP_DTA_STATUS Character(1) VARCHAR2(1) NOT NULL EIP Dta status
0=New
1=Error
2=Complete
3=In Process
4=Reprocess
5=Incomplete
6=Cancelled
7=Hold

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EIP_CTL_ID	Character(25)	VARCHAR2(25) NOT NULL	Enterprise Components EIP (enterprise integration point) control field
2	AUDIT_ACTN	Character(1)	VARCHAR2(1) NOT NULL	Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted. A=Add C=Change Old (PPR Only) D=Delete K=Change - Old Values N=Change - New Values O=Change - Original Values
3	PPRC_KEY_VALUE1	Character(60)	VARCHAR2(60) NOT NULL	Price Key value 1
4	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
5	TOTAL_COUNT	Number(7,0)	INTEGER NOT NULL	Total Count
6	PUBNODE	Character(30)	VARCHAR2(30) NOT NULL	Application Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.
7	MSGNAME	Character(30)	VARCHAR2(30) NOT NULL	Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
8	IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	In process flag
9	FULL_SYNC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Full Sync Indicator.
10	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.
11	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
12	EIP_DTA_STATUS	Character(1)	VARCHAR2(1) NOT NULL	EIP Dta status 0=New 1=Error 2=Complete 3=In Process 4=Reprocess 5=Incomplete 6=Cancelled 7=Hold