CAL_ADJP_ALL_VW

(SQL View)
Index Back

Adjustment Periods - No SetID

Used for prompting on Adjusting Period on a given Calendar ID

SELECT DISTINCT CALENDAR_ID ,ACCOUNTING_PERIOD ,PERIOD_NAME FROM PS_CAL_ADJP_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID
2 ADJUSTING_PERIOD Number(3,0) SMALLINT NOT NULL Adjustment Period
3 PERIOD_NAME Character(30) VARCHAR2(30) NOT NULL Period Name