SSR_RI_LCLVA_VW

(SQL View)
 Index Back

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_LOCATION' AND A.EFF_STATUS = 'A' AND A.SCC_CAF_ATTRIB_NM = B.SCC_CAF_ATTRIB_NM AND B.SCC_CAF_ATTR_TYPE = '03'

  • Parent record: SCC_CAF_RATRHDR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SSR_RI_LOCLVAL_NLD Character(20) VARCHAR2(20) NOT NULL Org Loc Long Descr CAF Attrib