CAF_FLST_UDT_VW

(SQL View)
 Index Back

SELECT H.OPRID , %subrec(CAF_FCTLSTK_SBR, H) , %subrec(CAF_FCTLSTF_SBR, D) , %subrec(CAF_FCTLSTHF_SR, H) , 'N' , F.CAF_FACTOR_NAME FROM PS_CAF_FLSTUSR_HDR H , PS_CAF_FLSTUSR_DTL D , PS_CAF_FACTOR_TBL F WHERE H.CAF_CONFIG_TYPE = D.CAF_CONFIG_TYPE AND H.CAF_CONFIG_ID = D.CAF_CONFIG_ID AND H.CAF_ANALYSIS_MODE = D.CAF_ANALYSIS_MODE AND H.CAF_FCTLST_ID = D.CAF_FCTLST_ID AND H.CAF_CONFIG_TYPE = F.CAF_CONFIG_TYPE AND H.CAF_CONFIG_ID = F.CAF_CONFIG_ID AND D.CAF_FACTOR_ID = F.CAF_FACTOR_ID 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

    14 CAF_DEFAULT_FLG Character(1) VARCHAR2(1) NOT NULL Default
    15 CAF_FACTOR_NAME Character(48) VARCHAR2(48) NOT NULL Factor Name