KK_FS_CF_VW

(SQL View)
 Index Back

Active non-affiliate LedGrp CF

Active, non-affiliate Ledger Group ChartFields. This is used by ledgers that won't support Affiliate like Commitment Control Ledgers. This view excludes project related chartfields and is used as prompt table in Funding Source Activities Inquiry.

SELECT DISTINCT A.SETID , A.CHARTFIELD , B.LONGNAME , P.PROMPT_TBL2 FROM PS_LED_GRP_FLD_TBL A , PSDBFLDLABL_VW B , PSDBFIELD F , PS_LED_GRP_TBL T , PS_FS_FLD_PROMPT P WHERE A.CHARTFIELD = B.FIELDNAME AND A.CHARTFIELD<>'CURRENCY_CD' AND A.CHARTFIELD<>'BUSINESS_UNIT' AND A.CHARTFIELD<>'STATISTICS_CODE' AND A.CHARTFIELD<>'BUDGET_PERIOD' AND A.CHARTFIELD<>'ACTIVITY_ID' AND A.CHARTFIELD<>'BUSINESS_UNIT_PC' AND A.CHARTFIELD<>'RESOURCE_TYPE' AND B.FIELDNAME = F.FIELDNAME AND F.FLDNOTUSED = 0 AND A.CHARTFIELD NOT IN ( SELECT X.FIELDNAME FROM PS_FS_CF_TEMPLATE X WHERE X.CF_TYPE = 'A') AND A.SETID = T.SETID AND A.LEDGER_GROUP = T.LEDGER_GROUP AND T.LEDGER_GROUP_TYPE IN ('E', 'R') AND A.CHARTFIELD = P.FIELDNAME

  • Related Language Record: KK_FS_CFLANG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 CHARTFIELD Character(18) VARCHAR2(18) NOT NULL ChartField
    3 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name
    4 PROMPT_TBL2 Character(15) VARCHAR2(15) NOT NULL Prompt Table 2

    Prompt Table: RECDEFN_VW