Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/HR2TRA01
Product: Human Resources (414)
Series: 3rd Party
Display Name: HR_Train_Course Group Display Name: HR Third Party
Physical Name: HR2TRA01
Technical Name: HR_Train_Course
Group Technical Name: HR_Third_Party
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | COURSENAME_I ![]() | Course Name | STR30_I0 | String | 30 | |
2 | COURSEID_I ![]() | Course ID | STR6_U0 | String | 6 | |
3 | COURSESUBJECT_I ![]() | Course Subject | STR60 | String | 60 | |
4 | ROOM_I ![]() | Room | STR15_I | String | 15 | |
5 | INSTRUCTOR_I ![]() | Instructor | STR20 | String | 20 | |
6 | COURSEPREREQS_I_1 ![]() | Course Prereqs[1] | ISTR6 | String | 6 | |
7 | COURSEPREREQS_I_2 ![]() | Course Prereqs[2] | ISTR6 | String | 6 | |
8 | COURSEPREREQS_I_3 ![]() | Course Prereqs[3] | ISTR6 | String | 6 | |
9 | COURSEPREREQS_I_4 ![]() | Course Prereqs[4] | ISTR6 | String | 6 | |
10 | COURSEPREREQS_I_5 ![]() | Course Prereqs[5] | ISTR6 | String | 6 | |
11 | COURSEINHOUSE_I ![]() | Course InHouse | CB_InHouse | Boolean | 0 | |
12 | COURSECOST_I ![]() | Course Cost | DLR8_LBN_UTR$2 | Currency | 13 | |
13 | EMPLOYEECOST_I ![]() | Employee Cost | DLR8_LBN_UTR$2 | Currency | 13 | |
14 | EMPLOYERCOST_I ![]() | Employer Cost | DLR8_LBN_UTR$2 | Currency | 13 | |
15 | INSTRUCTORFEE_I ![]() | Instructor Fee | DLR8_LBN_UTR$2 | Currency | 13 | |
16 | MISCCOST_I ![]() | Misc Cost | DLR8_LBN_UTR$2 | Currency | 13 | |
17 | CREDITHOURS_I ![]() | Credit Hours | DLR6_LBN_UT2 | Currency | 8 | |
18 | NOTESINDEX_I ![]() | Notes Index | DOLLAR | Currency | 0 | |
19 | DEX_ROW_ID ![]() | int | int | 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. |