CAF_FLSTCDTL_VW

(SQL View)
 Index Back

SELECT '_' , %subrec(CAF_FCTLSTK_SBR, H) , %subrec(CAF_FCTLSTF_SBR, D) , %subrec(CAF_FCTLSTHF_SR, H) FROM PS_CAF_FLSTCNF_HDR H , PS_CAF_FLSTCNF_DTL D WHERE %Join(COMMON_KEYS, CAF_FLSTCNF_HDR H, CAF_FLSTCNF_DTL D) AND H.EFF_STATUS = 'A'

  • Related Language Record: CAF_FLSTCDTL_LV

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 CAF_CONFIG_TYPE Character(4) VARCHAR2(4) NOT NULL Analysis Type
    RTBL=Real Time Bottom Line
    SYS=System
    USER=User Defined
    3 CAF_CONFIG_ID Character(30) VARCHAR2(30) NOT NULL Analysis ID
    4 CAF_ANALYSIS_MODE Character(1) VARCHAR2(1) NOT NULL Analysis Mode
    A=Analysis
    C=Comparison

    Default Value: C

    5 CAF_FCTLST_ID Character(36) VARCHAR2(36) NOT NULL Factor List ID
    6 CAF_SEQ_NUM Number(4,0) SMALLINT NOT NULL Sequence
    7 CAF_FACTOR_ID Character(30) VARCHAR2(30) NOT NULL Factor ID
    8 CAF_SUBFACTOR_ID Character(128) VARCHAR2(128) NOT NULL Subfactor ID
    9 CAF_SIZE Number(5,0) INTEGER NOT NULL Size
    10 CAF_LAYOUT Character(254) VARCHAR2(254) NOT NULL Position/Size
    11 CAF_FCTLST_NAME Character(48) VARCHAR2(48) NOT NULL Factor List Name
    12 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    13 CAF_PUBLIC_FLG Character(1) VARCHAR2(1) NOT NULL Public

    Y/N Table Edit

    Default Value: N