PROCESS_INSTANCED=Days
M=Months
W=Weeks
Y=Years
IT_MTRC_AG1_AET(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | IT_DURATION | Number(10,0) | DECIMAL(10) NOT NULL | Duration |
| 3 | IT_PERIOD | Character(1) | VARCHAR2(1) NOT NULL |
Period
D=Days M=Months W=Weeks Y=Years |
| 4 | COMPARISON_DT | Date(10) | DATE | Comparison Date |
| 5 | ASSET_SUBTYPE | Character(15) | VARCHAR2(15) NOT NULL | Asset Subtype |
| 6 | OPRID2 | Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 7 | IT_TIMESPAN_ID | Character(15) | VARCHAR2(15) NOT NULL | Inventory Age |
| 8 | IT_ALL_DEVICES | Character(15) | VARCHAR2(15) NOT NULL | All Devices |
| 9 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 10 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. |