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