AMREVAL_RQST

(SQL Table)
 Index Back

Revaluation Request

Revaluation Request Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID

Default Value: 1

4 PROCESS_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Process Frequency
A=Always Process
N=Don't Run
O=Process Once

Default Value: N

5 IMPAIR_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Impairment Frequency
A=Annually
M=Monthly
Q=Quarterly
S=Semiannually
6 PROCESS_STATUS Character(1) VARCHAR2(1) NOT NULL Process Status
A=Active
C=Successfully Completed
E=Completed With Errors
N=Not Yet Processed
P=Processing Now
X=No Success

Default Value: N

7 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_AM_NONVW

8 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name

Prompt Table: SP_REV_BK_NONVW

9 ASSET_FLAG Character(1) VARCHAR2(1) NOT NULL Select All Assets ?
A=All Assets with this criteria
N=A Range of Assets

Default Value: A

10 ASSET_ID_FROM Character(12) VARCHAR2(12) NOT NULL From Asset ID

Prompt Table: ASSET_FIN_VW

11 ASSET_ID_TO Character(12) VARCHAR2(12) NOT NULL Asset ID to

Prompt Table: ASSET_FIN_VW

12 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: OPER_UNIT_TBL

13 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField

Prompt Table: PRODUCT_TBL

14 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code

Prompt Table: FUND_TBL

15 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field

Prompt Table: CLASS_CF_TBL

16 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField

Prompt Table: PROGRAM_TBL

17 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference

Prompt Table: BUD_REF_TBL

18 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate

Prompt Table: AFFILIATE_VW

19 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1

Prompt Table: %EDIT_INTRA01

20 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate

Prompt Table: %EDIT_INTRA02

21 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1

Prompt Table: CHARTFIELD1_TBL

22 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2

Prompt Table: CHARTFIELD2_TBL

23 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3

Prompt Table: CHARTFIELD3_TBL

24 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
25 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
26 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
27 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
28 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
29 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
30 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: PROJECT_ID_VW

31 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPT_TBL

32 CATEGORY Character(5) VARCHAR2(5) NOT NULL Asset Category

Prompt Table: CATEGORY_TBL

33 COST_TYPE Character(1) VARCHAR2(1) NOT NULL Cost Type

Prompt Table: COST_TYPE_TBL

34 TRANS_DT Date(10) DATE NOT NULL Transaction Date
35 ACCOUNTING_DT Date(10) DATE NOT NULL The accounting entry construction date for a given transaction (a generic field that crosses multiple
36 PERCENT_PNL Signed Number(11,6) DECIMAL(9,6) NOT NULL Percent on Panels
37 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
38 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
39 INCLUDE_CUR_PD_DPR Character(1) VARCHAR2(1) NOT NULL Include Current Period Depr.

Y/N Table Edit

40 IMP_COMMENT_PB Character(1) VARCHAR2(1) NOT NULL Revaluation Comments
41 REVALUE_METHOD Character(1) VARCHAR2(1) NOT NULL Revaluation Method
C=Cost Based
D=Depr. Write-Off
I=Investment Property
42 REVALUE_METHOD_1 Character(1) VARCHAR2(1) NOT NULL Revaluation Method
C=Cost Based
D=Depr. Write-Off
I=Investment Property
N=Net Method
43 REVALUE_METHOD_3 Character(1) VARCHAR2(1) NOT NULL Revaluation Method
C=Cost Based
I=Investment Property
N=Net Method
44 FMV_PERCENT Signed Number(11,6) DECIMAL(9,6) NOT NULL FV Percentage(%)
45 NBV_PERCENT Signed Number(11,6) DECIMAL(9,6) NOT NULL NBV Percentage(%)
46 CONVENTION Character(2) VARCHAR2(2) NOT NULL Book Depreciation Convention or Cost Convention

Default Value: AM

Prompt Table: CONV_BOOK_VW

47 EXC_AST_IMP_DT_AFT Date(10) DATE Exclude Assets Impaired After
48 COPY_TO_OTH_BK Character(1) VARCHAR2(1) NOT NULL Copy Impairment to other books

Y/N Table Edit

49 USE_FMV Character(1) VARCHAR2(1) NOT NULL Use Fair Value

Y/N Table Edit

Default Value: N

50 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID

Prompt Table: PROFILE_TBL

51 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: LOCATION_TBL

52 COMMENTS Long Character CLOB Comment
53 REVAL_COST_TYPE Character(1) VARCHAR2(1) NOT NULL Cost Type for Revaluation
54 ASSET_CLASS Character(10) VARCHAR2(10) NOT NULL Asset Class

Prompt Table: ASSET_CLASS_TBL

55 GROUP_ASSET_ID Character(12) VARCHAR2(12) NOT NULL Group Asset ID

Prompt Table: BU_GRP_ASSET_VW

56 FV_TEMPLATE_ID Character(12) VARCHAR2(12) NOT NULL Fair Value Template ID

Prompt Table: AM_FV_TEMPLATE
Set Control Field: BUSINESS_UNIT

57 FV_GROUP_ID Character(20) VARCHAR2(20) NOT NULL FV Group ID used to group related FV Assets

Prompt Table: %EDITTABLE

58 VALUATION_METHOD Character(30) VARCHAR2(30) NOT NULL Valuation Method
59 VALUATION_PREMISE Character(1) VARCHAR2(1) NOT NULL Fair Value Valuation Premise: 1:In-Exchange;2:In-Use
1=In-Exchange
2=In-Use
60 FV_GROUP_BY Character(1) VARCHAR2(1) NOT NULL Fair Value Group By: 1:FV Group ID; 2:Cash Generating Unit; 3:Group Asset ID; 4:Parent ID
1=FV Group ID
2=Cash Generating Unit
3=Group Asset ID
4=Parent ID
61 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