SSR_RI_DPTAT_VW (SQL View)	Index Back
RIO Org Dept Attributes

SSR_RI_DPTAT_VW

(SQL View)

RIO Org Dept Attributes

SELECT A.SCC_CAF_ATTRIB_NM FROM PS_SCC_CAF_RECATTR A ,PS_SCC_CAF_ATTRIBS B WHERE A.RECNAME = 'ORG_DEPT' AND A.EFF_STATUS = 'A' AND A.SCC_CAF_ATTRIB_NM = B.SCC_CAF_ATTRIB_NM AND B.SCC_CAF_ATTR_TYPE = '01'

Parent record: SCC_CAF_RATRHDR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SSR_RI_DEPATTR_NLD Character(20) VARCHAR2(20) NOT NULL Org Dept CAF Attribute