MG_CAL_CODE_VW

(SQL View)
Index Back

Alternate Calendar Code View

03/04/97 RPS (CN# MG700-1.0): Search record added as part of calendar code enhancement.

select distinct(a.business_unit) ,a.calendar_code from PS_MG_CALENDAR_WK a, ps_bus_unit_opt_mg b where a.business_unit=b.business_unit and a.calendar_code<>b.calendar_code_pr

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BUMGOP_NONVW

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.