SCC_CM_PERSON (SQL Table)	Index Back
PERSON record Used by Inbound Constituent Web Service as a place holder before we move the data to the base transaction records via SOA

SCC_CM_PERSON

(SQL Table)

PERSON record

Used by Inbound Constituent Web Service as a place holder before we move the data to the base transaction records via SOA

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCC_UID Character(100) VARCHAR2(100) NOT NULL Universal Hub ID

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

3 BIRTHDATE Date(10) DATE Date of Birth

4 BIRTHPLACE Character(30) VARCHAR2(30) NOT NULL Birth Location

5 BIRTHCOUNTRY Character(3) VARCHAR2(3) NOT NULL Birth Country
Prompt Table: COUNTRY_TBL

6 BIRTHSTATE Character(6) VARCHAR2(6) NOT NULL Birth State
Prompt Table: BIRTHSTATE_VW

7 DT_OF_DEATH Date(10) DATE Date of Death

8 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCC_UID	Character(100)	VARCHAR2(100) NOT NULL	Universal Hub ID
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	BIRTHDATE	Date(10)	DATE	Date of Birth
4	BIRTHPLACE	Character(30)	VARCHAR2(30) NOT NULL	Birth Location
5	BIRTHCOUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Birth Country Prompt Table: COUNTRY_TBL
6	BIRTHSTATE	Character(6)	VARCHAR2(6) NOT NULL	Birth State Prompt Table: BIRTHSTATE_VW
7	DT_OF_DEATH	Date(10)	DATE	Date of Death
8	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.