| # |
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 |
FROMDATE |
Date(10) |
DATE |
From Date
|
| 4 |
THRUDATE |
Date(10) |
DATE |
End Date
|
| 5 |
ASOFDATE |
Date(10) |
DATE |
As of Date
|
| 6 |
NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Name
|
| 7 |
LM_ACT_CD |
Character(30) |
VARCHAR2(30) NOT NULL |
Activity Code
|
| 8 |
LM_ACT_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Activity ID
Prompt Table:
LM_ACT_CI_VW
|
| 9 |
LM_ACT_END_DT_FR |
Date(10) |
DATE |
End date from
|
| 10 |
LM_ACT_END_DT_TO |
Date(10) |
DATE |
Activity End date to
|
| 11 |
LM_ACT_START_DT_FR |
Date(10) |
DATE |
start date from
|
| 12 |
LM_ACT_START_DT_TO |
Date(10) |
DATE |
start date to
|
| 13 |
LM_ACTIVITY_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Activity Date
E=Class End Date
S=Class Start Date
Default Value: S
|
| 14 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
LM_BU_TBL_VW
|
| 15 |
LM_CI_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Catalog Item ID - System Generated ID Number associated with each Catalog Item
Prompt Table:
LM_CI_TBL
|
| 16 |
LM_EXP_DT |
Date(10) |
DATE |
Expiry Date for PO, TUs.
|
| 17 |
LM_EXPORT_DATE |
Date(10) |
DATE |
Export Date
|
| 18 |
LM_ITM_END_DT |
Date(10) |
DATE |
TU Pool Item End Date
|
| 19 |
LM_ITM_START_DT |
Date(10) |
DATE |
TU Pool Item Start Date.
|
| 20 |
LM_JOURNAL_DATE |
Date(10) |
DATE |
Specifies the date the journal was created.
|
| 21 |
LM_JOURNAL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.
Prompt Table:
LM_JRNL_ID_VW
|
| 22 |
LM_LE_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Learning Environment ID - System Generated number
Prompt Table:
LM_LE_OPRID_VW
|
| 23 |
LM_ORGANIZATION_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Organization ID
Default Value: 0
Prompt Table:
%EDITTABLE
|
| 24 |
LM_ORG_TYPE |
Character(15) |
VARCHAR2(15) NOT NULL |
Organization Type
|
| 25 |
LM_ORG_TYPE_RPT |
Character(4) |
VARCHAR2(4) NOT NULL |
Organization Type
ALL=All
CUST=Customer
DEPT=Department
Default Value: ALL
|
| 26 |
LM_PERSON_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
ELM Person ID
Default Value: 0
Prompt Table:
LM_PERS_NAME_VW
|
| 27 |
LM_PO_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Purchase Order Id. Unique key for purchase orders.
Prompt Table:
LM_ENRMT_PO_VW
|
| 28 |
LM_PO_NAME |
Character(20) |
VARCHAR2(20) NOT NULL |
PO Number field in the PO table.
Prompt Table:
LM_ENR_PO_SR_VW
|
| 29 |
LM_PO_PURCHASE_DT |
Date(10) |
DATE |
PO Purchase Date
|
| 30 |
LM_PRG_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Program ID is a unique identifier for curriculum and certification Programs.
Prompt Table:
LM_PRG_CD_SRVW
|
| 31 |
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
|
| 32 |
LM_PYMT_MTHD_RPT |
Character(4) |
VARCHAR2(4) NOT NULL |
Payment Method. The payment method for FI reports
ALL=All
CASH=Cash
CHCK=Check
CRCD=Credit Card
Default Value: ALL
|
| 33 |
LM_SUBLEDGER |
Character(15) |
VARCHAR2(15) NOT NULL |
The name of the Sub-Ledger.
Prompt Table:
LM_SUBLDG_ID_VW
|
| 34 |
LM_SUBLEDGER_DT |
DateTime(26) |
TIMESTAMP |
SubLedger Date - Date and Time row was written to SubLedger
|
| 35 |
LM_SUBLEDGER_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sub-Ledger ID. System Generated.
Prompt Table:
LM_SUBLDGR_SVW
|
| 36 |
LM_TU_POOL_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Training Unit Pool No. Unique key for Training Unit Pool Record.
Prompt Table:
LM_TU_POOL_VW
|
| 37 |
LM_TU_POOL_NAME |
Character(20) |
VARCHAR2(20) NOT NULL |
Training Unit Pool
|