LM_CS_COUNTER(SQL Table) |
Index Back |
---|---|
Counter TableTable to keep track of the current max number of all ids for Course Structure |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | LM_ATTACH_ID | Number(10,0) | DECIMAL(10) NOT NULL | Attachment ID - System generated unique ID created for each attachment. |
2 | LM_CATG_ID | Number(10,0) | DECIMAL(10) NOT NULL | Category ID - System generated number used to uniquely identify a Category. |
3 | LM_CI_ID | Number(10,0) | DECIMAL(10) NOT NULL | Catalog Item ID - System Generated ID Number associated with each Catalog Item |
4 | LM_DMTHD_ID | Number(10,0) | DECIMAL(10) NOT NULL | Delivery Method ID - This is a system generated number used to uniquely identify each new Delivery Method |
5 | LM_DMTHD_TYPE_ID | Number(10,0) | DECIMAL(10) NOT NULL | Delivery Method Type ID - This is a unique identifier for each delivery method type |
6 | LM_KWRD_ID | Number(10,0) | DECIMAL(10) NOT NULL | Keyword ID - This is a system generated number used as a unique identifier for the keyword table. |
7 | LM_KWRD_TYPE_ID | Number(10,0) | DECIMAL(10) NOT NULL | Keyword Type ID- System generated unique ID created with each new instance of a Keyword Type. |
8 | LM_LE_ID | Number(10,0) | DECIMAL(10) NOT NULL | Learning Environment ID - System Generated number |
9 | LM_NOTES_ID | Number(10,0) | DECIMAL(10) NOT NULL | Notes ID - System generated unique ID for each new note entered. |
10 | LM_CRSE_CD_ALPHA | Character(20) | VARCHAR2(20) NOT NULL | Alphabetical portion of the course code value for auto-generated course codes. |
11 | LM_CRSE_CD_NBR | Number(4,0) | SMALLINT NOT NULL | Numeric portion of the course code value for auto-generated course codes. |
12 | LM_ACT_CD_AUTO | Character(1) | VARCHAR2(1) NOT NULL |
Indicates whether to auto-generate the activity code from the course code.
Y/N Table Edit Default Value: N |