LM_CS_COUNTER

(SQL Table)
Index Back

Counter Table

Table 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