LM_MAS_PAY_VW

(SQL View)
 Index Back

Mass Enrollment Payments Rec

Mass Enrollment Payments Record

SELECT LM_SEQ_NBR , LM_PAY_SEQ_NBR , CURRENCY_CD , LM_ACT_FEE , LM_DP_CHGES , LM_FEE_NO_OF_TUS , LM_FEE_DP_TUS , LM_PYMT_MTHD , LM_TU_POOL_ID , BUSINESS_UNIT_GL , LM_ACCOUNT , LM_ALTACCT , LM_BUDGET_REF , LM_CHARTFIELD1 , LM_CHARTFIELD2 , LM_CHARTFIELD3 , LM_CLASS_FLD , LM_FUND_CODE , LM_HR_DEPTID , LM_OPERATING_UNIT , LM_PRODUCT , LM_PROGRAM_CODE , LM_PROJECT_ID , LM_SPLIT , LM_CHECK_NO , LM_ROUTING_NO , LM_BANK_NAME , LM_CHECK_DATE , LM_CHECK_EXP_DATE , EOEC_CCI_NUMBER , EOEC_CCI_TYPE , EOEC_CCI_STATUS , EOEC_CCI_FNAME , EOEC_CCI_LNAME , EOEC_CCI_APPEARS , EOEC_CCI_EXPMO , EOEC_CCI_EXPYR , EOEC_CCI_4DIGITS , EOEC_CCI_AUTH , EOEC_CCI_CVNUM , LM_EMAIL_ADDR , ADDRESS1 , ADDRESS2 , ADDRESS3 , ADDRESS4 , CITY , COUNTRY , STATE , POSTAL , LM_ROW_ADDED_DTTM , LM_ROW_ADDED_OPRID , LM_ROW_MAINT_DTTM , LM_ROW_MAINT_OPRID FROM PS_LM_ENRL_MAS_PAY

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LM_SEQ_NBR Number(10,0) DECIMAL(10) NOT NULL Sequence number to increment for the mass req record
2 LM_PAY_SEQ_NBR Number(10,0) DECIMAL(10) NOT NULL Sequence to increment for mass payments
3 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
4 LM_ACT_FEE Number(19,3) DECIMAL(18,3) NOT NULL Activity Fee -- The cost to the learner of enrolling in a class
5 LM_DP_CHGES Number(23,3) DECIMAL(22,3) NOT NULL Drop Charges
6 LM_FEE_NO_OF_TUS Number(14,3) DECIMAL(13,3) NOT NULL No of Training Units available/used.
7 LM_FEE_DP_TUS Number(14,3) DECIMAL(13,3) NOT NULL No of Training Units available/used.
8 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
9 LM_TU_POOL_ID Number(10,0) DECIMAL(10) NOT NULL Training Unit Pool No. Unique key for Training Unit Pool Record.
10 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL General Ledger Business Unit
11 LM_ACCOUNT Character(20) VARCHAR2(20) NOT NULL Account Chart Field

Prompt Table: %EDITTABLE9

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

Prompt Table: %EDITTABLE11

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

Prompt Table: %EDITTABLE13

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

Prompt Table: %EDITTABLE15

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

Prompt Table: %EDITTABLE16

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

Prompt Table: %EDITTABLE17

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

Prompt Table: %EDITTABLE7

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

Prompt Table: %EDITTABLE6

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

Prompt Table: LM_DEPT_CF_VW

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

Prompt Table: %EDITTABLE12

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

Prompt Table: %EDITTABLE14

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

Prompt Table: %EDITTABLE8

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

Prompt Table: %EDITTABLE10

24 LM_SPLIT Number(3,0) SMALLINT NOT NULL Split Percentage. The user can split theFee across various Department / Account Codes
25 LM_CHECK_NO Character(15) VARCHAR2(15) NOT NULL Check No used for payment
26 LM_ROUTING_NO Character(15) VARCHAR2(15) NOT NULL Routing No of the check
27 LM_BANK_NAME Character(80) VARCHAR2(80) NOT NULL Bank Name of the check used.
28 LM_CHECK_DATE Date(10) DATE Check Issue Date
29 LM_CHECK_EXP_DATE Date(10) DATE Check Expiry Date.
30 EOEC_CCI_NUMBER Character(200) VARCHAR2(200) NOT NULL Use in the Credit Card Number Capture Process
31 EOEC_CCI_TYPE Character(3) VARCHAR2(3) NOT NULL Credit Card Name

Prompt Table: EOEC_CCI_TP_VW

32 EOEC_CCI_STATUS Character(1) VARCHAR2(1) NOT NULL Hold Credit Card Status. Valid Values 1. Active 2. Inactive
A=Active
I=Inactive

Default Value: A

33 EOEC_CCI_FNAME Character(60) VARCHAR2(60) NOT NULL Use in the Credit Card Number Capture Process
34 EOEC_CCI_LNAME Character(60) VARCHAR2(60) NOT NULL Use in the Credit Card Number Capture Process
35 EOEC_CCI_APPEARS Character(80) VARCHAR2(80) NOT NULL Hold Credit Card Name as it appears in the Card
36 EOEC_CCI_EXPMO Character(2) VARCHAR2(2) NOT NULL Credit Card Expiry Month
01=January
02=February
03=March
04=April
05=May
06=June
07=July
08=August
09=September
10=October
11=November
12=December
37 EOEC_CCI_EXPYR Character(4) VARCHAR2(4) NOT NULL Use in the Credit Card Number Capture Process
2008=2008
2009=2009
2010=2010
2011=2011
2012=2012
2013=2013
2014=2014
2015=2015
2016=2016
2017=2017
2018=2018
2019=2019
38 EOEC_CCI_4DIGITS Character(4) VARCHAR2(4) NOT NULL Use in the Credit Card Number Capture Process
39 EOEC_CCI_AUTH Number(5,0) INTEGER NOT NULL Holds Credit Card Authorization Number. Few credit cards have some extra numbers, which is required for authoization.
40 EOEC_CCI_CVNUM Character(4) VARCHAR2(4) NOT NULL Card Verification Number
41 LM_EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email address
42 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
43 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
44 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
45 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
46 CITY Character(30) VARCHAR2(30) NOT NULL City
47 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
48 STATE Character(6) VARCHAR2(6) NOT NULL State
49 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
50 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
51 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
52 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
53 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid