Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PC30305
Product: Human Resources (414)
Series: Payroll
Display Name: PC Position Seats Detail History DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information. Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.
Physical Name: PC30305
Technical Name: pcPositionSeatsDetailHistorySeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 PLANCODE Plan STR15_LBAU String 15 2 JOBTITLE Job Title STR6_Payroll_Code String 6 3 TEMPSEAT Temporary Seat Boolean Boolean 0 4 SEAT Seat INT6 Long Integer 6 5 CHANGEDATE_I Change Date DT Date 8 6 SEQ_I Seq LINT_10 Long Integer 10 7 CHANGETIME_I Change Time TM Time 6 8 SEQNUMBR Sequence Number LI_Sequence_Number Long Integer 10 9 EMPLOYID Employee ID STR15_Employee_ID String 15 10 STRTDATE Start Date DT Date 8 11 ENDDATE End Date DT Date 8 12 ASSIGNMENTSTATUS Assignment Status DDL_AssignmentStatus Integer 0 13 PRIMARYPOSSEAT Primary Position/Seat CB Boolean 0 14 EXPIREDCB Expired CB Expired CB Boolean 0 15 INHERITSTATUS Inheritance Status DDL_InheritanceStatus Integer 0 16 Base_Step_Increased_On Base Step Increases On DDL_BaseStepIncreasesOn Integer 0 17 PYSTPTBLID Pay Step Table ID STR15_LBU String 15 18 Step Step INT3_RB0_U Integer 3 19 Step_Effective_Date Step Effective Date DT Date 8 20 PAYRATEBASEDON Pay Rate Based On GB Integer 0 21 PAYRATE Pay Rate DLR11_$S2 Currency 14 22 CHANGEBY_I Change By STR15_User_ID String 15 23 CHANGEREASON_I Change Reason STR30_I String 30 24 DEX_ROW_ID int int 10