SCC_PERS_SA_VW

(SQL View)
 Index Back

PERSON record

PERSON one of the core records in the database. It contains one row for every Person (EMPLID) in the system. It is the Parent record or PERS_DATA_EFFDT, EMPLOYMENT etc. You can create only one PERSONAL_DATA record per person.

SELECT A.EMPLID , A.BIRTHDATE , A.BIRTHPLACE , A.BIRTHCOUNTRY , A.BIRTHSTATE , A.DT_OF_DEATH , B.CAMPUS_ID , B.FERPA , B.VA_BENEFIT , B.PLACE_OF_DEATH , B.DEATH_CERTIF_NBR FROM PS_HCR_PERSON_I A , PS_PERSON_SA B WHERE A.EMPLID = B.EMPLID

  • Parent Record Of ACADPROGSRCHLNG ACAD_PROG_SRCH

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 BIRTHDATE Date(10) DATE Date of Birth
    3 BIRTHPLACE Character(30) VARCHAR2(30) NOT NULL Birth Location
    4 BIRTHCOUNTRY Character(3) VARCHAR2(3) NOT NULL Birth Country

    Prompt Table: COUNTRY_TBL

    5 BIRTHSTATE Character(6) VARCHAR2(6) NOT NULL Birth State

    Prompt Table: BIRTHSTATE_VW

    6 DT_OF_DEATH Date(10) DATE Date of Death
    7 CAMPUS_ID Character(16) VARCHAR2(16) NOT NULL Campus ID
    8 FERPA Character(1) VARCHAR2(1) NOT NULL FERPA
    9 VA_BENEFIT Character(1) VARCHAR2(1) NOT NULL VA Benefit
    10 PLACE_OF_DEATH Character(30) VARCHAR2(30) NOT NULL Place of Death
    11 DEATH_CERTIF_NBR Character(10) VARCHAR2(10) NOT NULL Death Certificate Nbr