WM_PE_INITIAL

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 SRVC_GRP_ID Character(10) VARCHAR2(10) NOT NULL Service Group

3 SHOP_ID Character(10) VARCHAR2(10) NOT NULL Shop Identification

4 PRIORITY_CD Character(3) VARCHAR2(3) NOT NULL Priority Code

5 SUM_1 Number(9,0) DECIMAL(9) NOT NULL Count

6 SUM_2 Number(9,0) DECIMAL(9) NOT NULL Count

7 SUM_3 Number(9,0) DECIMAL(9) NOT NULL Count

8 SUM_4 Number(9,0) DECIMAL(9) NOT NULL COUNT

9 SUM_TOTAL Number(9,0) DECIMAL(9) NOT NULL Total

10 DTTM_STAMP 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	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	SRVC_GRP_ID	Character(10)	VARCHAR2(10) NOT NULL	Service Group
3	SHOP_ID	Character(10)	VARCHAR2(10) NOT NULL	Shop Identification
4	PRIORITY_CD	Character(3)	VARCHAR2(3) NOT NULL	Priority Code
5	SUM_1	Number(9,0)	DECIMAL(9) NOT NULL	Count
6	SUM_2	Number(9,0)	DECIMAL(9) NOT NULL	Count
7	SUM_3	Number(9,0)	DECIMAL(9) NOT NULL	Count
8	SUM_4	Number(9,0)	DECIMAL(9) NOT NULL	COUNT
9	SUM_TOTAL	Number(9,0)	DECIMAL(9) NOT NULL	Total
10	DTTM_STAMP	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.