KK_KEY_CF_VW4

(SQL View)
Index Back

Dist valid setid,effdt,lg,cf

Valid KK Key ChartFields without considering Ruleset (SubType).

SELECT DISTINCT K.SETID1 , K.LEDGER_GROUP , K.EFFDT , K.CHARTFIELD , T.CF_ORDER FROM PS_KK_KEY_CF K , PS_FS_CF_TEMPLATE T WHERE K.CHARTFIELD = T.FIELDNAME AND T.CF_TYPE <> 'A' AND T.CF_ACTIVE_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
3 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 CHARTFIELD Character(18) VARCHAR2(18) NOT NULL ChartField
5 CF_ORDER Number(2,0) SMALLINT NOT NULL ChartField Sequence Order