CAL_DEFN_TB4_VW (SQL View)	Index Back
Calendar Defn TBL View Used to select Calendar ID when copying Budget rows from Microsoft Project to PeopleSoft Projects' Budgeting.

CAL_DEFN_TB4_VW

(SQL View)

Calendar Defn TBL View

Used to select Calendar ID when copying Budget rows from Microsoft Project to PeopleSoft Projects' Budgeting.

SELECT SETID , CALENDAR_ID , DESCR FROM PS_CAL_DEFN_TBL WHERE CALENDAR_TYPE = 'P'

Related Language Record: CAL_DEFN_TB4LVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID
Prompt Table: CAL_DEFN_TBL

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	CALENDAR_ID	Character(2)	VARCHAR2(2) NOT NULL	Calendar ID Prompt Table: CAL_DEFN_TBL
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description