CSO_BATCH_SCHEDULE

Details

Name	Columns
CSO_BATCH_SCHEDULE_PK	RECORD_ID

Name	Datatype	Length	Not-null	Comments
RECORD_ID	VARCHAR2	32	Yes	This is the primary key of the table.
DATE_ADDED	TIMESTAMP		Yes	This is the date that the record was added to the repository.
DATE_MODIFIED	TIMESTAMP			This is the date that the record was modified.
CREATED_BY	VARCHAR2	64	Yes	Who column: indicates the user who created the row.
LAST_UPDATED_BY	VARCHAR2	64	Yes	Who column: indicates the user who last updated the row.
JOB_REF_KEY	VARCHAR2	50	Yes	The non-localized name of the batch job
JOB_GROUP	VARCHAR2	50	Yes	The group to which this job belongs.
FREQUENCY	NUMBER		Yes	Frequency of this job, in minutes.
RUN_IMMEDIATELY	CHAR	1		Flag indicating if the batch job is to be run at the next opportunity.
AVOID_CONFLICT_SCHEDULE_ID	VARCHAR2	32		The recordid of another job in the batch schedule; if that other job is running it prevents this job from being run.
EXECUTION_RANK	NUMBER		Yes	The priority of each job. When search jobs runs; only job with highest priority is executed from scheduled jobs.
SEED_DATA_SOURCE	VARCHAR2	512		Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.
ORA_SEED_SET1	VARCHAR2	1	Yes	Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N.
ORA_SEED_SET2	VARCHAR2	1	Yes	Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N.

Index	Uniqueness	Tablespace	Columns
CSO_BATCH_SCHEDULE_U1	Unique	Default	RECORD_ID, ORA_SEED_SET1
CSO_BATCH_SCHEDULE_U11	Unique	Default	RECORD_ID, ORA_SEED_SET2