LM_PRG_SCN_VW(SQL View) |
Index Back |
---|---|
Program SectionProgram Section View |
SELECT A.LM_PRG_ID , A.EFFDT , A.LM_SCN_ID , A.LM_SCN , A.LM_ORDER , A.LM_SCN_ITEMS_REQ , A.LM_CEU_TOT , A.LM_SCN_INST , A.LM_EXPR_DT , A.LM_EXPR_DAYS , A.LM_GRACE_PD_DAYS , A.LM_EXPR_WRN_DAYS , A.LM_RECERT_WRN_DAYS , A.LM_RECERT_PD_DAYS FROM PS_LM_PRG_SCN 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_SCN_ID | Number(10,0) | DECIMAL(10) NOT NULL | Section ID |
4 | LM_SCN | Character(100) | VARCHAR2(100) NOT NULL | Section Name |
5 | LM_ORDER | Number(4,0) | SMALLINT NOT NULL | Order of Completion |
6 | LM_SCN_ITEMS_REQ | Number(3,0) | SMALLINT NOT NULL | Section Items Required |
7 | LM_CEU_TOT | Number(13,2) | DECIMAL(12,2) NOT NULL | Total Continuing Education Units |
8 | LM_SCN_INST | Character(254) | VARCHAR2(254) NOT NULL | Section Instructions |
9 | LM_EXPR_DT | Date(10) | DATE | Certification Expiration Date is a fixed, preset date when the certification will expire. |
10 | LM_EXPR_DAYS | Number(5,0) | INTEGER NOT NULL | This is a validity period used for notifying the learner. This is what is shown to the learner as the number of days that the Certificate is valid for. |
11 | LM_GRACE_PD_DAYS | Number(3,0) | SMALLINT NOT NULL | This is the number of days after expiration, that the actual expiration takes effect. |
12 | LM_EXPR_WRN_DAYS | Number(3,0) | SMALLINT NOT NULL | The expiration warning period is the number of days before certification or before re-certification expiration, in which a reminder notification is sent to the learner. |
13 | LM_RECERT_WRN_DAYS | Number(3,0) | SMALLINT NOT NULL | The recertification warning period is the number of days before re-certification expiration, in which a reminder notification is sent to the learner. |
14 | LM_RECERT_PD_DAYS | Number(5,0) | INTEGER NOT NULL | The re-certification period is the number of days after certification actually expires, within which the learner must complete the official re-certification path/program to reinstate certification status. |