LM_PRGREG_HSTVW

(SQL View)
 Index Back

Program Reg Table

Program Registration Table.

SELECT A.PSARCH_ID , A.PSARCH_BATCHNUM , A.LM_PRG_REG_ID , A.LM_ADHC_LRN_ID , A.LM_PRG_ID , A.LM_PERSON_ID , A.LM_ORGANIZATION_ID , A.LM_ACT_REQ , A.LM_TYPE , A.LM_PRG_STTS , A.LM_PRG_STTS_OLD , A.LM_APPR_ID , A.LM_APPROVED_ON , A.LM_STTS_CHANGE_DT , A.LM_REQUESTOR_ID , A.CURRENCY_CD , A.LM_PYMT_MTHD , A.LM_INITIATED_DT , A.LM_ENRL_DT , A.LM_COMPL_DT , A.LM_TARGET_CMPL_DT , A.LM_DP_DT , A.LM_CEU , A.LM_CREDIT_ID , A.LM_CREDIT_ON , A.LM_ENRLMT_DESCR , %subrec(LM_ACT_PRCE_SBR,A) , %subrec(LM_AMT_PRCE_SBR,A) ,%subrec(LM_ROWAUDIT_SBR,A) , A.LM_IS_APPR_LAUNCHD , A.LM_CERT_EFFDT , A.LM_EMPL_RCD FROM PS_LM_PRG_REG_HST A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
3 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.
4 LM_ADHC_LRN_ID Number(10,0) DECIMAL(10) NOT NULL Adhoc Learning 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_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
7 LM_ORGANIZATION_ID Number(15,0) DECIMAL(15) NOT NULL Organization ID
8 LM_ACT_REQ Character(1) VARCHAR2(1) NOT NULL Activity Required
N=No
Y=Yes
9 LM_TYPE Character(4) VARCHAR2(4) NOT NULL Type of the Enrollment. This field for now will have only one value STDD
ADHC=Adhoc
PLAN=Planned
RSRV=Reserved
STDD=Standard
10 LM_PRG_STTS Character(4) VARCHAR2(4) NOT NULL Program Reg Status
CANC=Dropped
COMP=Completed
DECL=Decline
ENRL=Registered
EXPR=Expired
INCO=Not Completed
INPO=In-Progress
PEAP=Pending Approval
PEPA=Pending Payment
PLAN=Planned
PPYA=Payment Approval
REIS=Reissue
REVK=Revoked
WAIV=Waived
WARN=Warning
11 LM_PRG_STTS_OLD Character(4) VARCHAR2(4) NOT NULL Prior Program Registration Status
COMP=Completed
ENRL=Registered
EXPR=Expired
INCO=Incomplete
INPO=In-Progress
PEAP=Pending Approval
PEPA=Pending Payment
PLAN=Planned
PPYA=Payment Approval
REIS=Reissue
WAIV=Waived
WARN=Warning
12 LM_APPR_ID Number(15,0) DECIMAL(15) NOT NULL Approver ID field
13 LM_APPROVED_ON DateTime(26) TIMESTAMP The date on which this Enrollment is Approved
14 LM_STTS_CHANGE_DT Date(10) DATE Status Chage Date
15 LM_REQUESTOR_ID Number(15,0) DECIMAL(15) NOT NULL Requestor
16 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
17 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
18 LM_INITIATED_DT Date(10) DATE The date on which the course was launched by the student. This applies only for WBT.
19 LM_ENRL_DT Date(10) DATE Enrollment/Registration Date
20 LM_COMPL_DT Date(10) DATE The date on which this Enrollment was marked Completed / InComplete
21 LM_TARGET_CMPL_DT Date(10) DATE The target date by which the student should complete the course. This field is only applicable for WBT activity and the Learning Period for the WBT activity is Enforced. If the Learning Period is not enforced, this field will hold no value.
22 LM_DP_DT Date(10) DATE Drop Date
23 LM_CEU Number(8,2) DECIMAL(7,2) NOT NULL Continuing Education Units
24 LM_CREDIT_ID Number(10,0) DECIMAL(10) NOT NULL Credit ID
25 LM_CREDIT_ON Date(10) DATE Credited On
26 LM_ENRLMT_DESCR Long Character(2000) VARCHAR2(2000) Comments
27 LM_ACT_FEE Number(19,3) DECIMAL(18,3) NOT NULL Activity Fee -- The cost to the learner of enrolling in a class
28 LM_DP_CHGES Number(23,3) DECIMAL(22,3) NOT NULL Drop Charges
29 LM_FEE_NO_OF_TUS Number(14,3) DECIMAL(13,3) NOT NULL No of Training Units available/used.
30 LM_FEE_DP_TUS Number(14,3) DECIMAL(13,3) NOT NULL No of Training Units available/used.
31 LM_AMT_PAID Number(23,3) DECIMAL(22,3) NOT NULL Amount Paid so far towards the Enrollment Fee
32 LM_PAID_DP_CHGES Number(23,3) DECIMAL(22,3) NOT NULL Drop Charges
33 LM_PAID_TUS Number(14,3) DECIMAL(13,3) NOT NULL No of Training Units available/used.
34 LM_PAID_DP_TUS Number(14,3) DECIMAL(13,3) NOT NULL No of Training Units available/used.
35 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
36 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
37 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
38 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid
39 LM_IS_APPR_LAUNCHD Character(1) VARCHAR2(1) NOT NULL This flag indicates whether approval was launched for the transaction.
40 LM_CERT_EFFDT Date(10) DATE Current Certification Date
41 LM_EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record umber