SCC_SFP_CAF_VW

(SQL View)
 Index Back

SFP SAFI Fully Enrolled CAF

This view lists common attributes associated to record ACAD_CALTRM_TBL

SELECT A.SCC_CAF_ATTRIB_NM , A.DESCR , A.SCC_CAF_ATTR_TYPE , B.DESCR FROM PS_SCC_CAF_ATTRIBS A , PS_SCC_CAF_ATTRTYP B , PS_SCC_CAF_RECATTR R WHERE A.SCC_CAF_ATTR_TYPE = B.SCC_CAF_ATTR_TYPE AND R.RECNAME = 'ACAD_CALTRM_TBL' AND A.SCC_CAF_ATTRIB_NM = R.SCC_CAF_ATTRIB_NM and A.SCC_CAF_ATTR_TYPE = '05'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SCC_CAF_ATTRIB_NM Character(20) VARCHAR2(20) NOT NULL Common Attribute
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 SCC_CAF_ATTR_TYPE Character(2) VARCHAR2(2) NOT NULL Attribute Type
4 SCC_CAF_DESCR Character(30) VARCHAR2(30) NOT NULL Attribute Type