LM_PRG_IDLM_PUSH_UPD_SEQDONE=Done
PEND=Pending
Default Value: PEND
Default Value: %Date
LM_PRG_PUSH_UPD(SQL Table) |
Index Back |
|---|---|
Program PushStaging table for Program Push |
| # | 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 | LM_PUSH_UPD_SEQ |
Number(10,0) | DECIMAL(10) NOT NULL | Update Sequence Number |
| 3 | LM_UPD_PUSH_STTS | Character(4) | VARCHAR2(4) NOT NULL |
Status
DONE=Done PEND=Pending Default Value: PEND |
| 4 | LM_PUSH_DT | Date(10) | DATE |
Push Date
Default Value: %Date |
| 5 | LM_UPD_EXPR_FLG | Character(4) | VARCHAR2(4) NOT NULL | Expire Certifications? |