| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 2 |
ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Identification
|
| 3 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 4 |
IT_TIMESPAN_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Inventory Age
|
| 5 |
IT_TIMESPAN_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Inventory Age Seq
|
| 6 |
ASSET_SUBTYPE |
Character(15) |
VARCHAR2(15) NOT NULL |
Asset Subtype
|
| 7 |
DISCO_SERIAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Serial ID
|
| 8 |
ARM_MFG_ID |
Character(50) |
VARCHAR2(50) NOT NULL |
ARM Manufacturer ID
|
| 9 |
MANUFACTURER |
Character(60) |
VARCHAR2(60) NOT NULL |
Manufacturer Name
|
| 10 |
DISCO_MFG_ID |
Character(50) |
VARCHAR2(50) NOT NULL |
Discovery Manufacturer ID
|
| 11 |
MANUFACTURER_B |
Character(60) |
VARCHAR2(60) NOT NULL |
Manufacturer Name
|
| 12 |
ARM_MODEL |
Character(30) |
VARCHAR2(30) NOT NULL |
Model
|
| 13 |
DISCO_MODEL |
Character(30) |
VARCHAR2(30) NOT NULL |
Model
|
| 14 |
MACHINENAME_DISCO |
Character(64) |
VARCHAR2(64) NOT NULL |
Machine Name from 3rd Party
|
| 15 |
TAG_NUMBER |
Character(12) |
VARCHAR2(12) NOT NULL |
Tag Number
|
| 16 |
DISCOVERY_DATE |
Date(10) |
DATE |
Last Inventory Date
|
| 17 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 18 |
DEPTID_2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Department ID
|
| 19 |
CSTDN_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Custodian Empl Id
|
| 20 |
CSTDN_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
ARM Custodian
|
| 21 |
CSTDN_PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telephone
|
| 22 |
CSTDN_EMAIL |
Character(70) |
VARCHAR2(70) NOT NULL |
Custodian's Email Address
|
| 23 |
CSTDN_LG_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
CFR=Canadian French
DUT=Dutch
ENG=English
ESP=Spanish
FRA=French
GER=German
INE=International English
ITA=Italian
JPN=Japanese
POR=Portuguese
|
| 24 |
CSTDN_MGR_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Custodian Manager's Employee I
|
| 25 |
CSTDN_MGR_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
ARM Custodian
|
| 26 |
CSTDN_MGR_PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telephone
|
| 27 |
CSTDN_MGR_EMAIL |
Character(70) |
VARCHAR2(70) NOT NULL |
Custodian Manager's Email
|
| 28 |
CSTDN_MGR_LG_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
CFR=Canadian French
DUT=Dutch
ENG=English
ESP=Spanish
FRA=French
GER=German
INE=International English
ITA=Italian
JPN=Japanese
POR=Portuguese
|
| 29 |
PUSER_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Primary User Empl Id
|
| 30 |
PUSER_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Primary User's Name
|
| 31 |
PUSER_EMAIL |
Character(70) |
VARCHAR2(70) NOT NULL |
Priary User's Email Address
|
| 32 |
PUSER_LG_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
CFR=Canadian French
DUT=Dutch
ENG=English
ESP=Spanish
FRA=French
GER=German
INE=International English
ITA=Italian
JPN=Japanese
POR=Portuguese
|
| 33 |
PUSER_MGR_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Primary User Manager's EMPLID
|
| 34 |
PUSER_MGR_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Primary User's Manager Name
|
| 35 |
PUSER_MGR_EMAIL |
Character(70) |
VARCHAR2(70) NOT NULL |
Primary User Manager's Email
|
| 36 |
PUSER_MGR_LG_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
CFR=Canadian French
DUT=Dutch
ENG=English
ESP=Spanish
FRA=French
GER=German
INE=International English
ITA=Italian
JPN=Japanese
POR=Portuguese
|
| 37 |
DISCO_LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Discovery Location Code
|
| 38 |
ARM_LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
ARM Location Code
|
| 39 |
IP_ADDRESS_DISCO |
Character(39) |
VARCHAR2(39) NOT NULL |
IP Address from Third Party
|
| 40 |
LOCATION_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Location
|
| 41 |
DTTM_STAMP |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 42 |
IT_SUBTYPE |
Character(15) |
VARCHAR2(15) NOT NULL |
IT Subtype
|
| 43 |
FINANCIAL_ASSET_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Capitalized Asset
N=Non Cap
Y=Capitalize
|
| 44 |
IT_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
ITAM Actions to apply
1=Retire a Non-Financial Asset
2=Email Custodian
3=Email Custodian's manager
4=Email Custodian and manager
5=Email Primary User
6=Email Primary user's manager
7=Email Primary User and Manager
8=Move to Inventory
9=Route Retirement to Finance
|
| 45 |
COST |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Cost
|
| 46 |
FMV |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Fair (Market) Value Amount
|
| 47 |
NET_BK_VALUE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Net Book Value
|
| 48 |
IN_LIST |
Character(1) |
VARCHAR2(1) NOT NULL |
Included in a Financial List
Y/N Table Edit
Default Value: N
|