OPRIDLM_PRG_REG_IDCASH=Cash
CHCK=Check
CHGB=ChargeBack
CRCD=Credit Card
NOAP=Not Applicable
PO=Purchase Order
SEL=Select...
TU=Training Units
N=No
Y=Yes
CE=Certification
CU=Curriculum
LM_PEN_PRG_REQ(SQL View) |
Index Back |
|---|---|
Training Request for ProgramTraining Request for Program |
| SELECT USR.OPRID , PRGREG.LM_PRG_REG_ID , PRGREG.LM_APPR_ID , PRGREG.LM_PERSON_ID , PRGREG.LM_PRG_ID , PRGREG.LM_ACT_FEE , PRGREG.LM_FEE_NO_OF_TUS , PRGREG.CURRENCY_CD , PRGREG.LM_PYMT_MTHD , PRGREG.LM_ACT_REQ , PRG.LM_PRG_LONG_NM , PERDTL.FIRST_NAME , PERDTL.LAST_NAME , PRG.LM_PRG_TYPE , PRGREG.LM_ENRL_DT , PERDTL.LM_NAME_DISPLAY , PRGREG.LM_CERT_EFFDT FROM PS_LM_PRG_REG_VW PRGREG , PS_LM_PRG PRG , PS_LM_PERS_DTL_VW PERDTL , PS_LM_REG_APR_XREF XREF , PS_EOAW_USERINST USR , PS_EOAW_STEPINST STEP WHERE PRGREG.LM_PRG_ID = PRG.LM_PRG_ID AND PRGREG.LM_PERSON_ID = PERDTL.LM_PERSON_ID AND PRGREG.LM_PRG_STTS IN ( 'PEAP' , 'PPYA') AND PRGREG.LM_ENRL_DT BETWEEN PRG.EFFDT AND PRG.LM_END_EFFDT AND XREF.LM_PRG_REG_ID = PRGREG.LM_PRG_REG_ID AND XREF.EOAWTHREAD_ID = STEP.EOAWTHREAD_ID AND XREF.EOAWPRCS_ID = STEP.EOAWPRCS_ID AND STEP.EOAWSTEP_INSTANCE = USR.EOAWSTEP_INSTANCE AND USR.EOAWSTEP_STATUS = 'P' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | LM_PRG_REG_ID |
Number(10,0) | DECIMAL(10) NOT NULL | The Program Registration ID is a unique identifier for a learner's program enrollment. |
| 3 | LM_APPR_ID | Number(15,0) | DECIMAL(15) NOT NULL | Approver ID field |
| 4 | LM_PERSON_ID | Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |
| 5 | LM_PRG_ID | Number(10,0) | DECIMAL(10) NOT NULL | Program ID is a unique identifier for curriculum and certification Programs. |
| 6 | LM_ACT_FEE | Number(19,3) | DECIMAL(18,3) NOT NULL | Activity Fee -- The cost to the learner of enrolling in a class |
| 7 | LM_FEE_NO_OF_TUS | Number(14,3) | DECIMAL(13,3) NOT NULL | No of Training Units available/used. |
| 8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 9 | LM_PYMT_MTHD | Character(4) | VARCHAR2(4) NOT NULL |
Payment Method. The payment method can be ChargeBack, Training Units
CASH=Cash CHCK=Check CHGB=ChargeBack CRCD=Credit Card NOAP=Not Applicable PO=Purchase Order SEL=Select... TU=Training Units |
| 10 | LM_ACT_REQ | Character(1) | VARCHAR2(1) NOT NULL |
Activity Required
N=No Y=Yes |
| 11 | LM_PRG_LONG_NM | Character(200) | VARCHAR2(200) NOT NULL | Program Long Name |
| 12 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name field |
| 13 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name Field |
| 14 | LM_PRG_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Program Type
CE=Certification CU=Curriculum |
| 15 | LM_ENRL_DT | Date(10) | DATE | Enrollment/Registration Date |
| 16 | LM_NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Name Display field |
| 17 | LM_CERT_EFFDT | Date(10) | DATE | Current Certification Date |