CAF_FLSTUHDR_VW

(SQL View)
Index Back

SELECT H.OPRID , %subrec(CAF_FCTLSTK_SBR, H) , %subrec(CAF_FCTLSTHF_SR, H) FROM PS_CAF_FLSTUSR_HDR H WHERE 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_FCTLST_NAME Character(48) VARCHAR2(48) NOT NULL Factor List Name
7 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

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

Y/N Table Edit

Default Value: N