AM_FV_RPT_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 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | SERVERNAMERUN | Character(8) | VARCHAR2(8) NOT NULL | Server Name - Runtime |
| 4 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 5 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 6 | BOOK | Character(10) | VARCHAR2(10) NOT NULL | Asset Book Name |
| 7 | PROFILE_ID | Character(10) | VARCHAR2(10) NOT NULL | Asset Profile ID |
| 8 | CATEGORY | Character(5) | VARCHAR2(5) NOT NULL | Asset Category |
| 9 | FV_INPUT_LEVEL | Character(1) | VARCHAR2(1) NOT NULL |
Fair Value Input Level. 1:Level1;2:Level2;3:Level4;4:All Level
1=Level 1 2=Level 2 3=Level 3 |
| 10 | RPT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
This field identifies the report type - Financial, Non-Financial or All.
1=Financial Assets 2=Non Financial Assets 3=All |
| 11 | TO_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Revalue Currency |
| 12 | 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. |
| 13 | FROM_FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | From Fiscal Year |
| 14 | FROM_PERIOD | Number(3,0) | SMALLINT NOT NULL | From Period |
| 15 | THRU_FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Thru Fiscal Year |
| 16 | THRU_PERIOD | Number(3,0) | SMALLINT NOT NULL | Thru Period |
| 17 | FROM_DATE | Date(10) | DATE | From Date |
| 18 | THRU_DATE | Date(10) | DATE | Through Date |
| 19 | PROCESSNAME | Character(12) | VARCHAR2(12) NOT NULL | Process Name |
| 20 | PROCESS_INSTANCE2 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 21 | PROCESS_INSTANCE3 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance 3 |
| 22 | RUNSTATUS | Character(2) | VARCHAR2(2) NOT NULL |
Process Scheduler Process Run Status
1=Cancel 10=Not Successful 11=Posted 12=Unable to post 13=Resend 14=Posting 15=Content Generated 16=Pending 17=Success With Warning 18=Blocked 19=Restart 2=Delete 3=Error 4=Hold 5=Queued 6=Initiated 7=Processing 8=Cancelled 9=Success |
| 23 | TIMEOUTMINUTES | Number(5,0) | INTEGER NOT NULL | Time out minutes |
| 24 | PRCSNAME | Character(12) | VARCHAR2(12) NOT NULL | Process Name |
| 25 | TEST | Character(1) | VARCHAR2(1) NOT NULL | Test |
| 26 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 27 | CURRENCY_CONVERT | Character(1) | VARCHAR2(1) NOT NULL | Currency Conversion |
| 28 | BUSINESS_UNIT2 | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 29 | ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 30 | FMV | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Fair (Market) Value Amount |