BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
ASSET_IDDTTM_STAMPAM_HGRID_HIS_VW(SQL View) |
Index Back |
|---|---|
Component Of Asset HistoryAsset Component move history |
| SELECT a.business_unit , a.asset_id , a.dttm_stamp , a.business_unit_1 , a.component_of_id , a.begin_dt , a.end_dt , a.dttm_stamp_prev FROM PS_AM_AST_COMP_HIS A |
| # | 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 |