SSR_BR_PECF_VW

(SQL View)
Index Back

Record Attributes

Prior Ed Org location Record 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 = '01'

  • Parent record: SCC_CAF_RATRHDR
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCC_CAF_ATTRIB_NM Character(20) VARCHAR2(20) NOT NULL Common Attribute

    Prompt Table: SCC_CAF_ATTR_VW