HCR_PERSON_I

(SQL View)
 Index Back

Interface VW for Person

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.

SELECT A.EMPLID ,A.BIRTHDATE ,A.BIRTHPLACE ,A.BIRTHCOUNTRY ,A.BIRTHSTATE ,A.DT_OF_DEATH FROM PS_PERSON A

  • Parent Record Of ERLY_FA_CTG_VW ERLY_FA_CTG_VW2 ERLY_FA_CTG_VW3 ERLY_FA_CTG_VW4 FA_ERN_SUM_VW HONOR_AWARD_CVW LN_DRVR_LIC_VW NSLDS_GEN SAE_LDAPADUSGLN SAE_LDAPADUSGVW SAE_LDAPNMUSGLN SAE_LDAPNMUSGVW SCCPU_STAGR_BND SCC_ADDR_BILL SCC_ADDR_BUSN SCC_ADDR_CAMP SCC_ADDR_CHK SCC_ADDR_DORM SCC_ADDR_H SCC_ADDR_HOME SCC_ADDR_L1_H SCC_ADDR_L2_H SCC_ADDR_LEGL SCC_ADDR_MAIL SCC_ADDR_OTH SCC_ADDR_OTH2 SCC_ADDR_PERM SCC_ADDR_PREF SCC_ADDR_VTRN SCC_CITIZ_HIST SCC_EQADDR_VW SCC_EQAD_ORD_VW SCC_EQAD_USG_VW SCC_EQNAMES_VW SCC_EQNM_ORD_VW SCC_EQNM_USG_VW SCC_IWI_TBL SCC_NAMES_H SCC_NAMES_L1_H SCC_PRIORWORK SEL_FATERMNR_VW SFA_ADDRESS_VW SFA_ADDR_ORD_VW SFA_ADDR_USG_VW SFA_CITIZSHPVW SFA_DRVR_LIC_VW STDNT_AGGR_LIFE STDNT_AID_MC STUDENT_AID UPG_CC801_C_AET

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Default Value: NEW

    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