LM_RM_COUNTER(SQL Table) |
Index Back |
|---|---|
RM Counter TableTable to keep track of the current max number of all ids for Resource Management |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_ACMDTN_ID | Number(10,0) | DECIMAL(10) NOT NULL | Accommodation ID |
| 2 | LM_ACT_ID | Number(10,0) | DECIMAL(10) NOT NULL | Activity ID |
| 3 | LM_EQP_ID | Number(10,0) | DECIMAL(10) NOT NULL | Equipment ID |
| 4 | LM_EQP_TYPE_ID | Number(10,0) | DECIMAL(10) NOT NULL | Equipment Type ID |
| 5 | LM_FCLTY_ID | Number(10,0) | DECIMAL(10) NOT NULL | Facility ID |
| 6 | LM_MTRL_ID | Number(10,0) | DECIMAL(10) NOT NULL | Material ID |
| 7 | LM_MTRL_TYPE_ID | Number(10,0) | DECIMAL(10) NOT NULL | Material Type ID |
| 8 | LM_ROLE_ID | Number(10,0) | DECIMAL(10) NOT NULL | Role ID |
| 9 | LM_ROOM_ID | Number(10,0) | DECIMAL(10) NOT NULL | Room ID |
| 10 | LM_ROOM_TYPE_ID | Number(10,0) | DECIMAL(10) NOT NULL | Room Type ID |
| 11 | LM_RSRV_RM_ID | Number(10,0) | DECIMAL(10) NOT NULL | Reserve Room ID |
| 12 | LM_SES_ID | Number(10,0) | DECIMAL(10) NOT NULL | Session ID |
| 13 | LM_TMPL_ID | Number(15,0) | DECIMAL(15) NOT NULL | Template ID |