PC Position Setup History (PC30301)

azurecurveProductsHuman Resources (414)PayrollPC Position Setup History (PC30301)

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: pcSetupPositionHistory

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1PLANCODE SearchPlanStringSTR15_LBAU15
2JOBTITLE SearchJob TitleStringSTR6_Payroll_Code6
3CHANGEDATE_I SearchChange DateDateDT8
4SEQ_I SearchSeqLong IntegerLINT_1010
5CHANGETIME_I SearchChange TimeTimeTM6
6DSCRIPTN SearchDescriptionStringSTR3030
7ACTINDX SearchAccount IndexLong IntegerLI_1414
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'].ACTINDX
8ATACRSTM SearchAuto Accrue Sick TimeBooleanCB_Accrue_Sick_Time:0
9ATACRVAC SearchAuto Accrue VacationBooleanCB_Accrue_Vacation:0
10BUDGETPERMSEATAMT SearchBudget Pemanent Seats AmountIntegerINT4_U04
11BUDGETTEMPSEATAMT SearchBudget Temp Seats AmountIntegerINT4_U04
12BUGETBENPERCENT SearchBudget Benefit PercentCurrencyDLR5_%28
13BUDGETTAXPERCENT SearchBudget Tax PercentCurrencyDLR5_%28
14BUDGETBENAMOUNT SearchBudget Benefit AmountCurrencyDLR11_$U214
15BUDGETTAXAMOUNT SearchBudget Tax AmountCurrencyDLR11_$U214
16Calc_Min_Wage_Bal SearchCalc Min Wage BalBooleanCB_CalcMinWageBal0
17WCACFPAY SearchWhich Cash Account For PayIntegerGB0
18CHANGEBY_I SearchChange ByStringSTR15_User_ID15
19CONTENDDTE SearchContract End DateDateDATE_L0
20CONTSTARTDTE SearchContract Start DateDateDATE6
21CREATDDT SearchCreated DateDateDT8
22CRUSRID SearchCreated User IDStringSTR15_User_ID15
23DEPRTMNT SearchDepartmentStringSTR6_Payroll_Code6
24DIVISIONCODE_I SearchDivision CodeStringSTR6_Payroll_Code6
25EEOCLASS_I SearchEEO ClassIntegerDDL_EEO0
26EMPLCLAS SearchEmployee ClassStringSTR15_Employee_Class15
27FLSASTATUS SearchFLSA StatusIntegerDDL_FLSA_Status0
28BUDGETEDFTE SearchBudgeted FTECurrencyDLR11_U214
29INHERITANCELOCK SearchInheritance LockBooleanCB0
30LOCATNID SearchLocation IDStringSTR15_Location_ID15
31NOTEINDX SearchNote IndexCurrencyDLR1414
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'].NOTEINDX
32NOTEINDX2 SearchNote Index2CurrencyDLR1414
33GROSSPAYINDEX SearchGross Pay IndexLong IntegerLI_1414
34BENEFITEXPINDEX SearchBenefits Expense IndexLong IntegerLI_1414
35WCOMPTAXEXPINDEX SearchW/Comp Tax Expense IndexLong IntegerLI_1414
36TAXBENEXPENSEINDEX SearchTaxable Benefit Expense IndexLong IntegerLI_1414
37EMPLYRFICAMEINDEX SearchEmployer FICA/ME IndexLong IntegerLI_1414
38EMPLYRFICASEINDEX SearchEmployer FICA/SE IndexLong IntegerLI_1414
39EMPLYRFUTAINDEX SearchEmployer FUTA IndexLong IntegerLI_1414
40EMPLYRSUTAINDEX SearchEmployer SUTA IndexLong IntegerLI_1414
41POSSTATUS SearchPosition StatusIntegerDDL_PosStatus0
42REPORTSTOPOS SearchReports To PositionStringSTR6_Payroll_Code6
43REVIEWSETUPCODE_I SearchReview Setup CodeStringSTR3030
44STMACMTH SearchSick Time Accrual MethodIntegerGB0
45SKTMACAM SearchSick Time Accrual AmountLong IntegerLI6_U26
46SKTMHPYR SearchSick Time Hours Per YearLong IntegerLI6_U26
47SKILLSETNUMBER_I SearchSkill Set NumberLong IntegerINT66
48SUPERVISORCODE_I SearchSupervisor CodeStringSTR6_U6
49EMPLOYMENTTYPE SearchType of EmploymentIntegerDDL_Employment_Type0
50UNIONDUESAMOUNT_I SearchUnion Dues AmountCurrencyDLR10_LB_TR$_013
51UNIONNAME_I SearchUnion NameStringSTR30_I030
52VACCRMTH SearchVacation Accrual MethodIntegerGB0
53VACCRAMT SearchVacation Accrual AmountLong IntegerLI6_U26
54VACAPRYR SearchVacation Hours Per YearLong IntegerLI6_U26
55WRNSTFLSBLWZR SearchWarn Sick Time Falls Below ZeroBooleanCB_WarnSickTimeFallsBelowZero0
56WRNVCNFLSBLWZR SearchWarn Vacation Falls Below ZeroBooleanCB_WarnVacationFallsBelowZero0
57WRKRCOMP SearchWorkers CompStringSTR6_Payroll_Code6
58CHANGEREASON_I SearchChange ReasonStringSTR30_I30
59CONTACTNUM_I SearchUnion Contract NumStringSTR3030
60TXTFIELD SearchText FieldTextTX3200032000
azurecurveProductsHuman Resources (414)PayrollPC Position Setup History (PC30301)

Leave a Reply

Your email address will not be published. Required fields are marked *