LM_BO003_UN4_VW

(SQL View)
Index Back

For External Payment Report

For External Payment Report

SELECT A.OPRID , A.RUN_CNTL_ID , A.LM_ORG_DESCR , A.LM_ORGANIZATION_ID , A.NAME , A.LM_LE_LONG_NM , A.LM_PRG_CD , A.LM_PRG_LONG_NM , A.LM_PRG_STTS , %DateNull , %DateNull , A.LM_AMT_PAID , A.CURRENCY_CD , A.LM_PYMT_MTHD , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , A.XLATLONGNAME , A.LM_PYMT_MTHD_STR FROM PS_LM_BO003_B4_VW A , PSOPTIONS B WHERE A.LANGUAGE_CD = B.LANGUAGE_CD

# 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 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 LM_ORG_DESCR Character(50) VARCHAR2(50) NOT NULL Customer Description
4 LM_ORGANIZATION_ID Number(15,0) DECIMAL(15) NOT NULL Organization ID
5 NAME Character(50) VARCHAR2(50) NOT NULL Name
6 LM_LE_LONG_NM Character(60) VARCHAR2(60) NOT NULL Learning Environment Long Name
7 LM_PRG_CD Character(30) VARCHAR2(30) NOT NULL Program Code is a user defined field. This field allows duplicates and is not part of the primary key structure.
8 LM_PRG_LONG_NM Character(200) VARCHAR2(200) NOT NULL Program Long Name
9 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
10 LM_START_DT Date(10) DATE Start Date
11 LM_END_DT Date(10) DATE End Date
12 LM_AMT_PAID Number(23,3) DECIMAL(22,3) NOT NULL Amount Paid so far towards the Enrollment Fee
13 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
14 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
15 COUNTY Character(30) VARCHAR2(30) NOT NULL County
16 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
17 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
18 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
19 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
20 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
21 CITY Character(30) VARCHAR2(30) NOT NULL City
22 STATE Character(6) VARCHAR2(6) NOT NULL State
23 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
24 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
25 LM_PYMT_MTHD_STR Character(30) VARCHAR2(30) NOT NULL Payment Method