OPR_DEF_TBL_AM

(SQL Table)
Index Back

Operator Defaults - PS/AM

Operator Defaults - PS/AM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Prompt Table: OPRID_VW

2 RPT_GROUP_ID Character(15) VARCHAR2(15) NOT NULL On-Line Reporting Group Id

Prompt Table: RPT_DRILLFLD_VW

3 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
4 TRANS_DT Date(10) DATE Transaction Date
5 EDIT_FIN_TBL Character(1) VARCHAR2(1) NOT NULL Edit Financial Information
A=All
D=Date Only
N=None

Default Value: N

6 EDIT_PHYA_TBL Character(1) VARCHAR2(1) NOT NULL Edit Phy A Information
A=All
N=None

Default Value: N

7 EDIT_PHYB_TBL Character(1) VARCHAR2(1) NOT NULL Edit Phy B Information
A=All
N=None

Default Value: N

8 RUN_AMIF1000_IMP Character(1) VARCHAR2(1) NOT NULL Impairment/Revaluation Process

Y/N Table Edit

Default Value: Y

9 GRP_IMP_PROC_OPT Character(30) VARCHAR2(30) NOT NULL Asset Management Integration

Y/N Table Edit

Default Value: N

10 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_AM_NONVW

11 SPACE_UOM Character(3) VARCHAR2(3) NOT NULL Space Unit of measure (Sq Feet or Sq Meters)

Prompt Table: UNITS_TBL
Set Control Field: UNIT_OF_MEASURE

12 PROPERTY_CLASS Character(2) VARCHAR2(2) NOT NULL Property Class
10=Site
20=Building
30=Floor
40=Area
50=Space
13 ARO_RUN_AMIF1000 Character(1) VARCHAR2(1) NOT NULL Asset Retirement Obligations

Y/N Table Edit

Default Value: N

14 EDIT_UNI_SW Character(1) VARCHAR2(1) NOT NULL Edit Unitization Information
A=All
N=None
O=Operational Asset Details

Default Value: O

15 EDIT_CON_SW Character(1) VARCHAR2(1) NOT NULL Edit Consolidation Information
A=All
N=None
O=Operational Asset Details

Default Value: O

16 CON_DFLT_DIST_SW Character(1) VARCHAR2(1) NOT NULL To Default Distribution Only

Y/N Table Edit

Default Value: N

17 EDIT_PREAM_SW Character(1) VARCHAR2(1) NOT NULL Edit Review AP/PO Information
A=All
D=Dates Only
N=None
O=Operational Asset Details

Default Value: O

18 EDIT_INTFCTXN_SW Character(1) VARCHAR2(1) NOT NULL Edit Review Transactions Info.
A=All
D=Dates Only
N=None
O=Operational Asset Details

Default Value: N

19 BUSINESS_UNIT_AT Character(5) VARCHAR2(5) NOT NULL Asset Tracking Business Unit.

Prompt Table: SP_BU_AM_NONVW