AM_AST_COMP_HIS(SQL Table) |
Index Back |
|---|---|
Component Of Asset History |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT |
| 2 | ASSET_ID |
Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 3 | DTTM_STAMP |
DateTime(26) | TIMESTAMP NOT NULL | 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. |
| 4 | BUSINESS_UNIT_1 | Character(5) | VARCHAR2(5) NOT NULL | Non-Joint Venture BU |
| 5 | COMPONENT_OF_ID | Character(12) | VARCHAR2(12) NOT NULL | Component of Asset |
| 6 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 7 | END_DT | Date(10) | DATE | End Date |
| 8 | DTTM_STAMP_PREV | DateTime(26) | TIMESTAMP | Data Time Stamp - Old |
| 9 | AM_HGRID_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Asset Component Hierarchy, Action Drop Down list
1=.....Choose Action .... 2=Insert Asset on Row Below 3=Remove Asset From Hierarchy 4=Focus on Selected Row 5=Focus on Top Asset 6=Move Component |
| 10 | AMI_REASON | Character(3) | VARCHAR2(3) NOT NULL |
Reason
HRE=Hierarchy Removal for Disposal HRU=Hierarchy Removal for Reuse REM=Remove REU=Reuse |
| 11 | AM_COMP_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
Source Transaction used to change the parent of the component.
1=Manage Asset Component Grid |
| 12 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 13 | COMPONENT_PREV | Character(12) | VARCHAR2(12) NOT NULL | Component of Asset |
| 14 | COMP_MOVE_COMMENT | Character(254) | VARCHAR2(254) NOT NULL | Comment the reason for changing the component from one parent asset to another |