LM_PRG_IDEFFDTDefault Value: LM_PRG.EFFDT
LM_KWRD_TYPE_IDPrompt Table: LM_KWRD_TYP_VW
LM_KWRD_IDPrompt Table: LM_KWRD_VW2
LM_PRG_KWRD_VW(SQL View) |
Index Back |
|---|---|
Program Keywords ViewProgram Keywords View |
| SELECT A.LM_PRG_ID , A.EFFDT , A.LM_KWRD_TYPE_ID , A.LM_KWRD_ID FROM PS_LM_PRG_KWRD 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: LM_PRG.EFFDT |
| 3 | 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.
Prompt Table: LM_KWRD_TYP_VW |
| 4 | 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.
Prompt Table: LM_KWRD_VW2 |