ERPRef.com

18 COLUMNS | 5 INDICIES 920 | H91 | F91320 Job Schedule

Schema	Name	Prefix	Columns	Indicies	Description	Type	Report	Category
920	F91320	JS	18	5	Job Schedule	Extra Features Files	H91: Design Tools	System Tables

Use the column checkboxes to build your query. Header columns sets/unsets all columns. For Create statements, use Allow Null checkboxes and default values inputs to tailor query as required.

18 COLUMNS | TOP 920 | H91 | F91320 Job Schedule

	Col#	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement

5 INDICIES | TOP 920 | H91 | F91320 Job Schedule

1: Job Start DateTime (Primary/Unique)

Element	Alias	Description	Sequence
1	SCHJBNM	Scheduled Job Name	Ascending
2	SCHSTTIME	Scheduled Start ANSI C UTC Time	Ascending

2: LaunchTimeDate

Element	Alias	Description	Sequence
1	SCHLNCTIME	Scheduled Launch ANSI C UTC Time	Ascending

3: Start DateTime

Element	Alias	Description	Sequence
1	SCHSTTIME	Scheduled Start ANSI C UTC Time	Ascending

4: Launch Env Launch Location

Element	Alias	Description	Sequence
1	LNCENVH	Launch Environment Name	Ascending
2	LNCDATP	Launch Location	Ascending

5: LaunchStatus Job Name

Element	Alias	Description	Sequence
1	SCHLNCSTAT	Scheduled Launch Status	Ascending
2	SCHJBNM	Scheduled Job Name	Ascending