HR_Train_Class (HR2TRA03)

Easily find this page again using the shortlink:

Product: Certification Manager (4933)
Series: 3rd Party

Display Name: HR_Train_Class
Physical Name: HR2TRA03
Technical Name: HR_Train_Class

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1COURSEID_I SearchCourse IDSTR6_U0String86
2ICLASSID_I SearchIClass IDSTR6_U0String86
3CLASSNAME_I SearchClass NameSTR30_I0String3230
4CLASSSTARTDATE_I SearchClass Start DateDTDate48
5CLASSENDDATE_I SearchClass End DateDTDate48
6CLASSSTARTTIME_I SearchClass Start TimeSTR_TimeString65
7CLASSENDTIME_I SearchClass End TimeSTR_TimeString65
8INSTRUCTOR_I SearchInstructorSTR20String2220
9ROOM_I SearchRoomSTR15_IString1615
10NUMBERENROLLED_I SearchNumber EnrolledINT9Long Integer49
11MAXNUMBER_I SearchMax NumberINT9Long Integer49
12NOTESINDEX_I SearchNotes IndexDOLLARCurrency100
13DEX_ROW_ID Searchintint1010

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.

Leave a Reply

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