MG_CAL_NON_VW (SQL View)	Index Back
MG Alt non work view

MG_CAL_NON_VW

(SQL View)

MG Alt non work view

select distinct a.business_unit, a.calendar_code, a.mfg_month, a.mfg_year from PS_MG_CAL_NON_WRK a group by a.business_unit, a.calendar_code, a.mfg_month, a.mfg_year

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 CALENDAR_CODE Character(10) VARCHAR2(10) NOT NULL This code is for a group of dates associated with exchange (stock, money, commodity) traded future or option contracts.

3 MFG_MONTH Number(2,0) SMALLINT NOT NULL Month

4 MFG_YEAR Number(4,0) SMALLINT NOT NULL Year

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	CALENDAR_CODE	Character(10)	VARCHAR2(10) NOT NULL	This code is for a group of dates associated with exchange (stock, money, commodity) traded future or option contracts.
3	MFG_MONTH	Number(2,0)	SMALLINT NOT NULL	Month
4	MFG_YEAR	Number(4,0)	SMALLINT NOT NULL	Year