KK_SUBTYPE_VW

(SQL View)
Index Back

Rule Set by Budget Type View


SELECT DISTINCT LEDGER_GROUP ,SUBTYPE ,CALENDAR_ID FROM PS_KK_SUBTYPE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
2 SUBTYPE Character(10) VARCHAR2(10) NOT NULL Ruleset
3 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID

Prompt Table: CAL_BP_VW
Set Control Field: SETID1