Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PC30301
Product: Human Resources (414)
Series:
Display Name: PC Position Setup History
Physical Name: PC30301
Technical Name: pcSetupPositionHistorySeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 PLANCODE 
Plan String STR15_LBAU 15 2 JOBTITLE Job Title String STR6_Payroll_Code 6 3 CHANGEDATE_I Change Date Date DT 8 4 SEQ_I Seq Long Integer LINT_10 10 5 CHANGETIME_I Change Time Time TM 6 6 DSCRIPTN Description String STR30 30 7 ACTINDX Account Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['PC Position Setup History'].ACTINDX AS 'PC Position Setup History-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
PC30301 AS ['PC Position Setup History']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['PC Position Setup History'].ACTINDX = ['Account Index Master'].ACTINDX8 ATACRSTM Auto Accrue Sick Time Boolean CB_Accrue_Sick_Time: 0 9 ATACRVAC Auto Accrue Vacation Boolean CB_Accrue_Vacation: 0 10 BUDGETPERMSEATAMT Budget Pemanent Seats Amount Integer INT4_U0 4 11 BUDGETTEMPSEATAMT Budget Temp Seats Amount Integer INT4_U0 4 12 BUGETBENPERCENT Budget Benefit Percent Currency DLR5_%2 8 13 BUDGETTAXPERCENT Budget Tax Percent Currency DLR5_%2 8 14 BUDGETBENAMOUNT Budget Benefit Amount Currency DLR11_$U2 14 15 BUDGETTAXAMOUNT Budget Tax Amount Currency DLR11_$U2 14 16 Calc_Min_Wage_Bal Calc Min Wage Bal Boolean CB_CalcMinWageBal 0 17 WCACFPAY Which Cash Account For Pay Integer GB 0 18 CHANGEBY_I Change By String STR15_User_ID 15 19 CONTENDDTE Contract End Date Date DATE_L 0 20 CONTSTARTDTE Contract Start Date Date DATE 6 21 CREATDDT Created Date Date DT 8 22 CRUSRID Created User ID String STR15_User_ID 15 23 DEPRTMNT Department String STR6_Payroll_Code 6 24 DIVISIONCODE_I Division Code String STR6_Payroll_Code 6 25 EEOCLASS_I EEO Class Integer DDL_EEO 0 26 EMPLCLAS Employee Class String STR15_Employee_Class 15 27 FLSASTATUS FLSA Status Integer DDL_FLSA_Status 0 28 BUDGETEDFTE Budgeted FTE Currency DLR11_U2 14 29 INHERITANCELOCK Inheritance Lock Boolean CB 0 30 LOCATNID Location ID String STR15_Location_ID 15 31 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['PC Position Setup History'].NOTEINDX AS 'PC Position Setup History-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
PC30301 AS ['PC Position Setup History']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['PC Position Setup History'].NOTEINDX = ['Record Notes Master'].NOTEINDX32 NOTEINDX2 Note Index2 Currency DLR14 14 33 GROSSPAYINDEX Gross Pay Index Long Integer LI_14 14 34 BENEFITEXPINDEX Benefits Expense Index Long Integer LI_14 14 35 WCOMPTAXEXPINDEX W/Comp Tax Expense Index Long Integer LI_14 14 36 TAXBENEXPENSEINDEX Taxable Benefit Expense Index Long Integer LI_14 14 37 EMPLYRFICAMEINDEX Employer FICA/ME Index Long Integer LI_14 14 38 EMPLYRFICASEINDEX Employer FICA/SE Index Long Integer LI_14 14 39 EMPLYRFUTAINDEX Employer FUTA Index Long Integer LI_14 14 40 EMPLYRSUTAINDEX Employer SUTA Index Long Integer LI_14 14 41 POSSTATUS Position Status Integer DDL_PosStatus 0 42 REPORTSTOPOS Reports To Position String STR6_Payroll_Code 6 43 REVIEWSETUPCODE_I Review Setup Code String STR30 30 44 STMACMTH Sick Time Accrual Method Integer GB 0 45 SKTMACAM Sick Time Accrual Amount Long Integer LI6_U2 6 46 SKTMHPYR Sick Time Hours Per Year Long Integer LI6_U2 6 47 SKILLSETNUMBER_I Skill Set Number Long Integer INT6 6 48 SUPERVISORCODE_I Supervisor Code String STR6_U 6 49 EMPLOYMENTTYPE Type of Employment Integer DDL_Employment_Type 0 50 UNIONDUESAMOUNT_I Union Dues Amount Currency DLR10_LB_TR$_0 13 51 UNIONNAME_I Union Name String STR30_I0 30 52 VACCRMTH Vacation Accrual Method Integer GB 0 53 VACCRAMT Vacation Accrual Amount Long Integer LI6_U2 6 54 VACAPRYR Vacation Hours Per Year Long Integer LI6_U2 6 55 WRNSTFLSBLWZR Warn Sick Time Falls Below Zero Boolean CB_WarnSickTimeFallsBelowZero 0 56 WRNVCNFLSBLWZR Warn Vacation Falls Below Zero Boolean CB_WarnVacationFallsBelowZero 0 57 WRKRCOMP Workers Comp String STR6_Payroll_Code 6 58 CHANGEREASON_I Change Reason String STR30_I 30 59 CONTACTNUM_I Union Contract Num String STR30 30 60 TXTFIELD Text Field Text TX32000 32000