SCC_PERSON_VCVW (SQL View)	Index Back
Person change messaging table

SCC_PERSON_VCVW

(SQL View)

Person change messaging table

SELECT PROCESS_INSTANCE , SCC_SEQ_ID , SCC_SEQ_ID3 , EMPLID , BIRTHDATE , BIRTHPLACE , BIRTHCOUNTRY , BIRTHSTATE , DT_OF_DEATH , LAST_CHILD_UPDDTM , ' ' FROM PS_SCC_PERSON_STG WHERE AUDIT_ACTN = 'C' OR AUDIT_ACTN = ' ' OR AUDIT_ACTN = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 SCC_SEQ_ID Number(10,0) DECIMAL(10) NOT NULL Sequence ID

3 SCC_SEQ_ID3 Number(3,0) SMALLINT NOT NULL Sequence Nbr

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

5 BIRTHDATE Date(10) DATE Date of Birth

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

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

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

9 DT_OF_DEATH Date(10) DATE Date of Death

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

11 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	SCC_SEQ_ID	Number(10,0)	DECIMAL(10) NOT NULL	Sequence ID
3	SCC_SEQ_ID3	Number(3,0)	SMALLINT NOT NULL	Sequence Nbr
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	BIRTHDATE	Date(10)	DATE	Date of Birth
6	BIRTHPLACE	Character(30)	VARCHAR2(30) NOT NULL	Birth Location
7	BIRTHCOUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Birth Country Prompt Table: COUNTRY_TBL
8	BIRTHSTATE	Character(6)	VARCHAR2(6) NOT NULL	Birth State Prompt Table: BIRTHSTATE_VW
9	DT_OF_DEATH	Date(10)	DATE	Date of Death
10	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.
11	AUDIT_ACTN	Character(1)	VARCHAR2(1) NOT NULL	Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted. A=Add C=Change Old (PPR Only) D=Delete K=Change - Old Values N=Change - New Values O=Change - Original Values