HR_Train_Course (HR2TRA01)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/HR2TRA01

Display Name: HR_Train_Course
Physical Name: HR2TRA01
Technical Name: HR_Train_Course

Group Display Name: HR Third Party
Group Technical Name: HR_Third_Party

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	SQL DB Length	Keyable Length
1	COURSENAME_I	Course Name	STR30_I0	String	32	30
2	COURSEID_I	Course ID	STR6_U0	String	8	6
3	COURSESUBJECT_I	Course Subject	STR60	String	62	60
4	ROOM_I	Room	STR15_I	String	16	15
5	INSTRUCTOR_I	Instructor	STR20	String	22	20
6	COURSEPREREQS_I_1	Course Prereqs[1]	ISTR6	String	8	6
7	COURSEPREREQS_I_2	Course Prereqs[2]	ISTR6	String	8	6
8	COURSEPREREQS_I_3	Course Prereqs[3]	ISTR6	String	8	6
9	COURSEPREREQS_I_4	Course Prereqs[4]	ISTR6	String	8	6
10	COURSEPREREQS_I_5	Course Prereqs[5]	ISTR6	String	8	6
11	COURSEINHOUSE_I	Course InHouse	CB_InHouse	Boolean	2	0
12	COURSECOST_I	Course Cost	DLR8_LBN_UTR$2	Currency	10	13
13	EMPLOYEECOST_I	Employee Cost	DLR8_LBN_UTR$2	Currency	10	13
14	EMPLOYERCOST_I	Employer Cost	DLR8_LBN_UTR$2	Currency	10	13
15	INSTRUCTORFEE_I	Instructor Fee	DLR8_LBN_UTR$2	Currency	10	13
16	MISCCOST_I	Misc Cost	DLR8_LBN_UTR$2	Currency	10	13
17	CREDITHOURS_I	Credit Hours	DLR6_LBN_UT2	Currency	10	8
18	NOTESINDEX_I	Notes Index	DOLLAR	Currency	10	0
19	DEX_ROW_ID		int	int	10	10
	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.