HR_ASG_INT_CTX (SQL Table)	Index Back
Installed Integration Context Installed Integration Context Record in 9.1, row is inserted if Clairvia integration is on, and employee is enrolled/unenrolled/deleted or terminated at savepostchange time so message handler on Clairvia version of messages will know to publish additional Clairvia messages (person basic, jpm profile, workforce).

HR_ASG_INT_CTX

(SQL Table)

Installed Integration Context

Installed Integration Context Record in 9.1, row is inserted if Clairvia integration is on, and employee is enrolled/unenrolled/deleted or terminated at savepostchange time so message handler on Clairvia version of messages will know to publish additional Clairvia messages (person basic, jpm profile, workforce).

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
Default Value: PER_ORG_ASGN.EMPL_RCD

3 INT_APP_TYPE Character(3) VARCHAR2(3) NOT NULL Integration Application Type
RCT=Taleo
SCH=Scheduling Integration
Default Value: SCH

4 INTEGR_PROD_CD Character(3) VARCHAR2(3) NOT NULL Integration Product Code
CV=Clairvia Scheduling
OWS=Oracle Workforce Scheduling
TI=Taleo
Default Value: CV

5 HR_INT_STATUS Character(1) VARCHAR2(1) NOT NULL Integration Status - used by clairvia integration. 'E' means need to enroll employee in clairvia and generate add messages. 'U' means need to unenroll employee in clairvia and generate workforce_cv_Sync message. 'D' means need to delete employee in clairvia and generate person_basic_cv_sync_eff message.
D=Deleted
E=Enrolled
U=Unenrolled/Terminated

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record Default Value: PER_ORG_ASGN.EMPL_RCD
3	INT_APP_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Integration Application Type RCT=Taleo SCH=Scheduling Integration Default Value: SCH
4	INTEGR_PROD_CD	Character(3)	VARCHAR2(3) NOT NULL	Integration Product Code CV=Clairvia Scheduling OWS=Oracle Workforce Scheduling TI=Taleo Default Value: CV
5	HR_INT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Integration Status - used by clairvia integration. 'E' means need to enroll employee in clairvia and generate add messages. 'U' means need to unenroll employee in clairvia and generate workforce_cv_Sync message. 'D' means need to delete employee in clairvia and generate person_basic_cv_sync_eff message. D=Deleted E=Enrolled U=Unenrolled/Terminated