EmpSalH

EmpUID	Employee Unique ID	BigID	12
StartDate	Starting Date	SmallDate	32
CompanyID	Company Identifier	SmallID	12
AplyShiftD	Apply Shift Diff Flag	Varchar	1
Emp401KFlg	Employee 401K (Y/N)	Varchar	1
EmpS125Flg	Employee Section 125 (Y/N)	Varchar	1
HoursPerWk	Hours Per Week	Number	22
Notes	Comments	Text	16000
PayPeriod	Pay Period	Enum	1		ENUM D Daily W Weekly B Bi-Weekly S Semi-Monthly M Monthly
Period	Period	Long	12
CurrencyType	Indicates the windows currency type	Long	12
SalaryAmt	Salary Amount	Number	22
SalaryType	Salary Type (E, N, H, X)	Enum	1		ENUM E Salary Exempt H Hourly Non-Exempt N Salary Non-Exempt X Hourly Exempt
SalaryUnit	Salary Unit (M, W, B)	Enum	1		ENUM H Hour W Week M Month Y Year
SalChgCode	Salary Change Reason Code	BigID	12
ShiftCode	Shift Code	Enum	1		ENUM D Day N Night S Swing
PayrollCode	Payroll Code	Varchar	25
CompPlanID	Unique identifier for a compensation plan.	BigID	12
PayGradeID	Unique identifier for a pay grade	BigID	12
StopDate	Ending Date	Date	32
HpChgTS		Timestamp	32
LstModBy	Last Modified By Name	Varchar	40
LstModDate	Last Modified Date	Date	32
LockSeqNbr	*SYSTEM* Row Sequence Nbr	Long	12