PI_SYSTEM_SETUP(SQL Table) |
Index Back |
|---|---|
PI System Parameters |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  FIELDNAME_PI_SCAN |
Character(18) | VARCHAR2(18) NOT NULL |
PI Scan Field Name
Prompt Table: PI_SCAN_FLD_VW |
| 2 | RECNAME_PI_BASIS |
Character(15) | VARCHAR2(15) NOT NULL |
PI Basis Record Name
Prompt Table: PI_BASIS_VW |
| 3 | RECNAME_PI_TARGET |
Character(15) | VARCHAR2(15) NOT NULL |
Target Record
Prompt Table: PI_TARGET_VW |
| 4 | PI_TRANS_TYPE |
Character(3) | VARCHAR2(3) NOT NULL |
Transaction Type
ADD=Asset Non-Financial Add ASU=Asset Software Update AUP=Asset Update IHI=Inventory History Insert PHY=Physical Change REL=Operating Lease Retire REN=Non Capital Retirement RET=Asset Retirement TRF=Asset Transfer TRN=Non Capital Transfer TRO=Operating Lease Transfer |
| 5 | MC_DEFN_ID | Character(30) | VARCHAR2(30) NOT NULL |
Mass Change Definition
Prompt Table: MC_DEFN |