JOB_CONTROL (SQL Table)	Index Back
ETL Job Control This record is used on each source application database for EPM. It is used to control change data capture. The ETL map will extract only those rows of data whose tr

JOB_CONTROL

(SQL Table)

ETL Job Control

This record is used on each source application database for EPM. It is used to control change data capture. The ETL map will extract only those rows of data whose tr

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 JOBID Character(10) VARCHAR2(10) NOT NULL Job ID

2 TABLE_NAME Character(30) VARCHAR2(30) NOT NULL Table Name

3 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive

4 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	JOBID	Character(10)	VARCHAR2(10) NOT NULL	Job ID
2	TABLE_NAME	Character(30)	VARCHAR2(30) NOT NULL	Table Name
3	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive
4	LAST_UPDATE_DTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.