POI_CS1_VW

(SQL View)
Index Back

POI_CS1_VW CS Students

View of Persons of Interest with the 00009 Type Relationship - Campus Solutions

SELECT DISTINCT '00009' , P.EMPLID , ' ' ,'A' ,%DateNull ,%DateNull FROM PS_PER_POI_TYPE P , PS_STDNT_CAREER A where P.EMPLID =A.EMPLID (+) and P.POI_TYPE = '00009'

  • Parent record: PERSON
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 POI_TYPE Character(5) VARCHAR2(5) NOT NULL Defines the Transactional usage of POIs in HRMS.

    Prompt Table: POI_TYPE_TBL

    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    3 EMPL_RCD_CHAR Character(3) VARCHAR2(3) NOT NULL Empl_rcd# character field
    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    5 START_DATE Date(10) DATE Start Date for Gen Standing PO
    6 END_DATE Date(10) DATE End Date