ERPRef.com

209 COLUMNS | 14 INDICIES 812 | 05A | F060116 Employee Master Information

Schema	Name	Prefix	Columns	Indicies	Description	Type	Report	Category
812	F060116	YA	209	14	Employee Master Information	Master Files	05A: OW HR & PR Foundation	AS400 Coexistence 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.

209 COLUMNS | TOP 812 | 05A | F060116 Employee Master Information

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

14 INDICIES | TOP 812 | 05A | F060116 Employee Master Information

1: AddressNumber (Primary/Unique)

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending

2: Social Security Number

Element	Alias	Description	Sequence
1	SSN	Employee Tax ID	Ascending

5: Home BU Job Code +A

Element	Alias	Description	Sequence
1	HMCU	Business Unit - Home	Ascending
2	JBCD	Job Type (Craft) Code	Ascending
3	JBST	Job Step	Descending
4	ALPH	Name - Alpha	Ascending

6: Job Code Job Step +A

Element	Alias	Description	Sequence
1	JBCD	Job Type (Craft) Code	Ascending
2	JBST	Job Step	Descending
3	ALPH	Name - Alpha	Ascending

7: PR Lockout ID Update Flag

Element	Alias	Description	Sequence
1	USR	Payroll Lockout Identification	Ascending
2	UFLG	Update Flag	Ascending

8: Date Next Rev Supervisor +A

Element	Alias	Description	Sequence
1	NRVW	Date - Next Review	Ascending
2	ANPA	Supervisor	Ascending
3	TINC	Type of Increase Next Review	Ascending

9: Supervisor Type of Inc +A

Element	Alias	Description	Sequence
1	ANPA	Supervisor	Ascending
2	TINC	Type of Increase Next Review	Ascending
3	NRVW	Date - Next Review	Ascending

10: Type of Inc Supervisor +A

Element	Alias	Description	Sequence
1	TINC	Type of Increase Next Review	Ascending
2	ANPA	Supervisor	Ascending
3	NRVW	Date - Next Review	Ascending

11: Home BU Check Route Code +A (Unique)

Element	Alias	Description	Sequence
1	HMCU	Business Unit - Home	Ascending
2	MAIL	Routing Code - Check	Ascending
3	AN8	Address Number	Ascending

12: Supervisor Address Number (Unique)

Element	Alias	Description	Sequence
1	ANPA	Supervisor	Ascending
2	AN8	Address Number	Ascending

13: Address Number Supervisor (Unique)

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	ANPA	Supervisor	Ascending

14: Address Number Job Type A+

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	JBCD	Job Type (Craft) Code	Ascending
3	JBST	Job Step	Ascending

15: Alternate Employee Number

Element	Alias	Description	Sequence
1	OEMP	Additional Employee No	Ascending

17: Company Home Union Code A+

Element	Alias	Description	Sequence
1	HMCO	Company - Home	Ascending
2	UN	Union Code	Ascending
3	HMCU	Business Unit - Home	Ascending
4	AN8	Address Number	Ascending