SCC_PERSON_H

(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. Campus Solutions hollow view for the core PERSONAL table. Data is actually sourced from the Service Oriented Architecture.

SELECT ' ' , %DateNull , ' ' , ' ' , ' ' , %DateNull , %DateTimeNull FROM %Table(INSTALLATION_SA)

# 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: HCR_STATE_I

6 DT_OF_DEATH Date(10) DATE Date of Death
7 LAST_CHILD_UPDDTM DateTime(26) TIMESTAMP Used to indicate the last update to any data belonging to this logical object. For PER_ORG_ASGN - this means any update to its children in JOB_DATA that do not have their own date. For PERSON - this means any update to its children in PERSONAL_DATA that do not have their own date.