LM_FI_ACTPMT_VW

(SQL View)
 Index Back

Curriculum Payment View

View containing all the Curriculum payment Rows in LM_ENRLMT_PYMT that are ready to write to the ELM Sub-Ledger.

SELECT A.LM_ENRLMT_ID , A.LM_PERSON_ID , A.LM_ACT_ID , B.LM_ACT_TYPE , A.LM_STTS , B.LM_START_DT , B.LM_END_DT , A.LM_PYMT_ID , A.LM_ENRLMT_TYPE , A.LM_DT_PYMT_RECV , A.LM_PYMT_MTHD , A.LM_AMT_PAID , A.LM_PAID_DP_CHGES , A.CURRENCY_CD , A.BUSINESS_UNIT_GL , %subrec(LM_CF_SBR, A) , A.LM_SUBLEDGER_STAT , A.PROCESS_INSTANCE , A.LM_ROW_ADDED_DTTM FROM PS_LM_ENRL_PYMT_VW A , PS_LM_ACT_VW B , PS_LM_SUBLEDG_UPDT C WHERE A.LM_CURR_PYMT = 'Y' AND A.LM_ENRLMT_TYPE = 'ACT' AND A.LM_SUBLEDGER_STAT IN ('PEN','UPD') AND A.LM_ACT_ID = B.LM_ACT_ID AND C.LM_ACT_TYPE = B.LM_ACT_TYPE AND C.LM_STTS = A.LM_STTS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LM_ENRLMT_ID Number(10,0) DECIMAL(10) NOT NULL Enrollment ID
2 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
3 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
4 LM_ACT_TYPE Character(4) VARCHAR2(4) NOT NULL Activity Type
BLND=Blended
SCHD=Scheduled
SELF=Self Paced
5 LM_STTS Character(4) VARCHAR2(4) NOT NULL Enrollment Status
CANC=Dropped
COMP=Completed
DECL=Denied
ENRL=Enrolled
INCO=Not Completed
INPO=In-Progress
MACT=Moved to New Activity
NOTS=Not Started
PEAP=Pending Approval
PEPA=Pending Payment
PLAN=Planned
PPYA=Payment Approval
RQST=Learning Request
WAIV=Waived
WTLT=Waitlisted
6 LM_START_DT Date(10) DATE Start Date
7 LM_END_DT Date(10) DATE End Date
8 LM_PYMT_ID Number(10,0) DECIMAL(10) NOT NULL Payment ID
9 LM_ENRLMT_TYPE Character(3) VARCHAR2(3) NOT NULL Enrollment Type could be activity, curriculum or adhoc learning
ACT=Activity Enrollment
ADH=Adhoc Enrollment
CUR=Curriculum Enrollment
10 LM_DT_PYMT_RECV DateTime(26) TIMESTAMP Date on which the payment was received
11 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
12 LM_AMT_PAID Number(23,3) DECIMAL(22,3) NOT NULL Amount Paid so far towards the Enrollment Fee
13 LM_PAID_DP_CHGES Number(23,3) DECIMAL(22,3) NOT NULL Drop Charges
14 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
15 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL General Ledger Business Unit
16 LM_ACCOUNT Character(20) VARCHAR2(20) NOT NULL Account Chart Field

Prompt Table: %EDITTABLE9

17 LM_ALTACCT Character(20) VARCHAR2(20) NOT NULL Alternate Account Chartfield

Prompt Table: %EDITTABLE11

18 LM_BUDGET_REF Character(20) VARCHAR2(20) NOT NULL Budget Reference Chartfield

Prompt Table: %EDITTABLE13

19 LM_CHARTFIELD1 Character(20) VARCHAR2(20) NOT NULL Chartfield 1

Prompt Table: %EDITTABLE15

20 LM_CHARTFIELD2 Character(20) VARCHAR2(20) NOT NULL Chartfield 2

Prompt Table: %EDITTABLE16

21 LM_CHARTFIELD3 Character(20) VARCHAR2(20) NOT NULL Chartfield 3

Prompt Table: %EDITTABLE17

22 LM_CLASS_FLD Character(20) VARCHAR2(20) NOT NULL Class Chart Field

Prompt Table: %EDITTABLE7

23 LM_FUND_CODE Character(20) VARCHAR2(20) NOT NULL Fund Code

Prompt Table: %EDITTABLE6

24 LM_HR_DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: LM_DEPT_CF_VW

25 LM_OPERATING_UNIT Character(20) VARCHAR2(20) NOT NULL Operating Unit ChartField

Prompt Table: %EDITTABLE12

26 LM_PRODUCT Character(20) VARCHAR2(20) NOT NULL Product Chartfield

Prompt Table: %EDITTABLE14

27 LM_PROGRAM_CODE Character(20) VARCHAR2(20) NOT NULL Program Chart Field

Prompt Table: %EDITTABLE8

28 LM_PROJECT_ID Character(20) VARCHAR2(20) NOT NULL Project Chart Field

Prompt Table: %EDITTABLE10

29 LM_SUBLEDGER_STAT Character(3) VARCHAR2(3) NOT NULL Sub Ledger Flag is used in payment table(LM_ENRLMT_PYMT). Its used by Financial Integration team for posting items to the Sub Ledger.
PEN=Pending
POS=Posted
UPD=Updated
30 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
31 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added