WM_PERIOD_DIM

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 WM_COST_PERIOD Character(20) VARCHAR2(20) NOT NULL Period

2 CALENDAR_TYPE Character(1) VARCHAR2(1) NOT NULL Type of Calendar
B=Budget Calendar
D=Detail Calendar
I=Summary Budget Period Calendar
P=Budget Period Calendar
S=Summary Calendar
T=Promo Mgmt Sales Calendar

3 BEGIN_DT Date(10) DATE Begin Date

4 END_DT Date(10) DATE End Date

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

6 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	WM_COST_PERIOD	Character(20)	VARCHAR2(20) NOT NULL	Period
2	CALENDAR_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Type of Calendar B=Budget Calendar D=Detail Calendar I=Summary Budget Period Calendar P=Budget Period Calendar S=Summary Calendar T=Promo Mgmt Sales Calendar
3	BEGIN_DT	Date(10)	DATE	Begin Date
4	END_DT	Date(10)	DATE	End Date
5	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
6	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
7	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.