CAF_FLSTUDTL_VW

(SQL View)
 Index Back

SELECT H.OPRID , %subrec(CAF_FCTLSTK_SBR, H) , %subrec(CAF_FCTLSTF_SBR, D) , %subrec(CAF_FCTLSTHF_SR, H) FROM PS_CAF_FLSTUSR_HDR H , PS_CAF_FLSTUSR_DTL D WHERE %Join(COMMON_KEYS, CAF_FLSTUSR_HDR H, CAF_FLSTUSR_DTL D) AND H.EFF_STATUS = 'A'

# 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