LM_PRG_IDDefault Value: %date
10=Active
20=Inactive
30=Pending
CE=Certification
CU=Curriculum
LM_PRG_VER_VW(SQL View) |
Index Back |
|---|---|
Program SES ViewUse for Program SES View.. |
| SELECT A.LM_PRG_ID , A.EFFDT , A.LM_PRG_STATUS , A.LM_PRG_TYPE , A.LM_PRG_CD , A.LM_PRG_LONG_NM , A.LM_PRG_SHORT_NM , A.LM_END_EFFDT , A.LM_PRG_DESCR , A.LM_CERT_ID , A.LM_ALLOW_WAIVER , A.LM_EXPR_DT ,' ' , 0 , 0 , 0 , A.LM_CMPL_PD_DAYS , A.LM_ROW_MAINT_DTTM , A.LM_INT_PRICE , A.LM_EXT_PRICE , A.LM_TRNG_UT , A.CURRENCY_CD , M300.MESSAGE_TEXT , M301.MESSAGE_TEXT , M302.MESSAGE_TEXT , M307.MESSAGE_TEXT FROM PS_LM_PRG A LEFT OUTER JOIN PSMSGCATDEFN M300 ON M300.MESSAGE_SET_NBR = 18088 AND M300.MESSAGE_NBR = 300 LEFT OUTER JOIN PSMSGCATDEFN M301 ON M301.MESSAGE_SET_NBR = 18088 AND M301.MESSAGE_NBR = 301 LEFT OUTER JOIN PSMSGCATDEFN M302 ON M302.MESSAGE_SET_NBR = 18088 AND M302.MESSAGE_NBR = 302 LEFT OUTER JOIN PSMSGCATDEFN M307 ON M307.MESSAGE_SET_NBR = 18088 AND M307.MESSAGE_NBR = 307 WHERE %CurrentDateIn BETWEEN A.EFFDT AND A.LM_END_EFFDT AND (A.LM_EXPR_DT >= %CurrentDateIn OR A.LM_EXPR_DT IS NULL) |
| # | 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_PRG_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Program Status
10=Active 20=Inactive 30=Pending |
| 4 | LM_PRG_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Program Type
CE=Certification CU=Curriculum |
| 5 | LM_PRG_CD | Character(30) | VARCHAR2(30) NOT NULL | Program Code is a user defined field. This field allows duplicates and is not part of the primary key structure. |
| 6 | LM_PRG_LONG_NM | Character(200) | VARCHAR2(200) NOT NULL | Program Long Name |
| 7 | LM_PRG_SHORT_NM | Character(10) | VARCHAR2(10) NOT NULL | Program Short Name |
| 8 | LM_END_EFFDT | Date(10) | DATE | The end effective date, automatically maintained, there's a doc on how this works, so read it |
| 9 | LM_PRG_DESCR | Character(254) | VARCHAR2(254) NOT NULL | Program Description |
| 10 | LM_CERT_ID | Number(10,0) | DECIMAL(10) NOT NULL | Certification ID |
| 11 | LM_ALLOW_WAIVER | Character(1) | VARCHAR2(1) NOT NULL | Allow Waiver Credit is a flag to determine whether learners can get ad-hoc credit for any items in a program. |
| 12 | LM_EXPR_DT | Date(10) | DATE | Certification Expiration Date is a fixed, preset date when the certification will expire. |
| 13 | LM_KWRD | Character(30) | VARCHAR2(30) NOT NULL | Keyword - Used to store all keywords |
| 14 | LM_OBJV_ID | Number(10,0) | DECIMAL(10) NOT NULL | Objective ID. System Generated ID Number associated with each Objective. |
| 15 | LM_CATG_ID | Number(10,0) | DECIMAL(10) NOT NULL | Category ID - System generated number used to uniquely identify a Category. |
| 16 | LM_LRNR_GROUP_ID | Number(15,0) | DECIMAL(15) NOT NULL | Learner Group ID - Business Role/ Student Group ID |
| 17 | LM_CMPL_PD_DAYS | Number(3,0) | SMALLINT NOT NULL | Completion Period is the period used to determine the target completion date for the learner. |
| 18 | LM_ROW_MAINT_DTTM | DateTime(26) | TIMESTAMP | Row Maintainted DateTime |
| 19 | LM_INT_PRICE | Number(19,3) | DECIMAL(18,3) NOT NULL | Internal Learner - Price |
| 20 | LM_EXT_PRICE | Number(19,3) | DECIMAL(18,3) NOT NULL | External Learner - Price |
| 21 | LM_TRNG_UT | Number(14,3) | DECIMAL(13,3) NOT NULL | Training Units - Price |
| 22 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 23 | LM_SRCH_COUNTRY | Character(30) | VARCHAR2(30) NOT NULL | Country Description |
| 24 | LM_SRCH_STATE | Character(30) | VARCHAR2(30) NOT NULL | State Description |
| 25 | LM_SRCH_CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 26 | LM_SRCH_UP_EVENTS | Character(100) | VARCHAR2(100) NOT NULL | Upcoming Events |