AV_ACTN_SOL_VW2

(SQL View)
Index Back

Constituent action

Solicitors for constituents actions. This view selects unitl solicitors that have been assigned to a constituents action.

SELECT DISTINCT A.INSTITUTION, A.EMPLID, A.EXT_ORG_ID, A.UNIT_CD, B.DESCR FROM PS_AV_CNST_ACTN A, PS_AV_UNIT_TBL B WHERE A.INSTITUTION=B.INSTITUTION AND A.UNIT_CD=B.UNIT_CD AND A.SOL_ASGN_TYPE='U'

  • Related Language Record: AVACTNSOLVW2LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    3 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
    4 UNIT_CD Character(11) VARCHAR2(11) NOT NULL Unit Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description