LM_PRG_PRQ_VW(SQL View) |
Index Back |
---|---|
Program Prerequisites ViewProgram Prerequisites View |
SELECT A.LM_PRG_ID , A.EFFDT , A.LM_DISP_ORDER , A.LM_OBJ_ID , A.LM_PRQ_OBJ_TYPE , A.LM_REVIEW_RATING , A.LM_PRQ_REL , A.LM_PRQ_PRIORITY FROM PS_LM_PRG_PRQ A |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | LM_PRG_ID | Number(10,0) | DECIMAL(10) NOT NULL | Program ID is a unique identifier for curriculum and certification Programs. |
2 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
3 | LM_DISP_ORDER | Number(10,0) | DECIMAL(10) NOT NULL | Display Order - A number indicating the ascending order in which the child category will appear under the parent. |
4 | LM_OBJ_ID | Number(10,0) | DECIMAL(10) NOT NULL |
Object ID - This value is relies upon the Object Type. The Object ID will either be the Catalog Item ID or the Learning Objective ID.
Prompt Table: %EDITTABLE |
5 | LM_PRQ_OBJ_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Prerequisite Object Type - The Object Type consists of a list with the following values: Mandatory Item, Catalog Item Learning Objective or Learning Objective.
10=Course 20=Objective 30=Program Default Value: 10 |
6 | LM_REVIEW_RATING | Character(1) | VARCHAR2(1) NOT NULL | REview points for Rating models from HRMS |
7 | LM_PRQ_REL | Character(2) | VARCHAR2(2) NOT NULL |
The Pre Requisite Relationship translates
10=And 20=Or 30=End Default Value: 30 |
8 | LM_PRQ_PRIORITY | Number(1,0) | SMALLINT NOT NULL | Prerequisite Priority, 0-9 9 being the highest priority, 0 being standard, only 0 enabled for V1 |