Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/HRTST022
Product: Certification Manager (4933)
Series: 3rd Party
Display Name: HR_Tests 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: HRTST022
Technical Name: HR_TestsSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 EMPID_I Emp ID STR15_Employee_ID String 15 2 EMPID_I Emp ID STR15_Employee_ID_I String 15 3 ISEQUENCENUMBER_I ISequence Number IINT2 Integer 2 4 ISEQUENCENUMBER_I ISequence Number INT2 Integer 2 5 TESTCODE_I Test Code STR6_I String 6 6 STRTDATE Start Date DT Date 8 7 TESTSCORE_I Test Score STR20 String 20 8 NOTESINDEX_I Notes Index DOLLAR Currency 0 9 CHANGEBY_I Change By STR15_User_ID String 15 10 CHANGEDATE_I Change Date DT Date 8 11 EXPNDATE Expiration Date DT_Date Date 6 12 DEX_ROW_ID int int 10