EMPLIDDefault Value: PER_ORG_ASGN.EMPLID
EMPL_RCDDefault Value: PER_ORG_ASGN.EMPL_RCD
INT_APP_TYPERCT=Taleo
SCH=Scheduling Integration
INTEGR_PROD_CDCV=Clairvia Scheduling
OWS=Oracle Workforce Scheduling
TI=Taleo
PERORGASGINT_CV(SQL View) |
Index Back |
|---|---|
PER_ORG_ASG_INT MSG ClairviaClone of PER_ORG_ASG_INT record for Clairvia Fullsync message |
| SELECT INTG.EMPLID , INTG.EMPL_RCD , INTG.INT_APP_TYPE , INTG.INTEGR_PROD_CD , INTG.ENROLLED_FLAG FROM PS_PER_ORG_ASG_INT INTG WHERE INTG.INT_APP_TYPE = 'SCH' AND INTG.INTEGR_PROD_CD = 'CV' AND INTG.ENROLLED_FLAG = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Default Value: PER_ORG_ASGN.EMPLID |
| 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 |
| 4 | INTEGR_PROD_CD |
Character(3) | VARCHAR2(3) NOT NULL |
Integration Product Code
CV=Clairvia Scheduling OWS=Oracle Workforce Scheduling TI=Taleo |
| 5 | ENROLLED_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Enrolled Flag |