INSTALAM_BTF_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TYPE_ADD	Character(3)	VARCHAR2(3) NOT NULL	Trans Type - Add
2	TYPE_ADJUSTMENT	Character(3)	VARCHAR2(3) NOT NULL	Trans Type - Adjustment
3	TYPE_TRANSFER	Character(3)	VARCHAR2(3) NOT NULL	Trans Type - Transfer In
4	TYPE_DEPR	Character(3)	VARCHAR2(3) NOT NULL	Depreciation
5	TYPE_PRIOR_DEPR	Character(3)	VARCHAR2(3) NOT NULL	Prior Depreciation
6	TYPE_RECATEGORIZE	Character(3)	VARCHAR2(3) NOT NULL	Recategorize
7	TYPE_RESERVE_ADJ	Character(3)	VARCHAR2(3) NOT NULL	Reserve Adjustment
8	TYPE_RETIRE	Character(3)	VARCHAR2(3) NOT NULL	Trans Type - Class Retire
9	TYPE_REINSTATE	Character(3)	VARCHAR2(3) NOT NULL	Reinstatement
10	TYPE_LEASE_PAYMENT	Character(3)	VARCHAR2(3) NOT NULL	Lease Payment
11	TYPE_BOOK_CHANGE	Character(3)	VARCHAR2(3) NOT NULL	Book Change
12	TYPE_SUSPEND	Character(3)	VARCHAR2(3) NOT NULL	Trans Type - Suspend
13	TYPE_RESUME	Character(3)	VARCHAR2(3) NOT NULL	Trans Type - Resume
14	TYPE_BUDGET_DEPR	Character(3)	VARCHAR2(3) NOT NULL	Budgeted Depr
15	TYPE_LEASE_PAY_BUD	Character(3)	VARCHAR2(3) NOT NULL	Lease Budget
16	TYPE_INFLATION	Character(3)	VARCHAR2(3) NOT NULL	Inflation Transactions
17	TYPE_RRC	Character(3)	VARCHAR2(3) NOT NULL	Retro Rate Change for Groups
18	LAST_INTFC_ID	Number(8,0)	INTEGER NOT NULL	Last Interface ID Default Value: 10000000
19	JV_PROCESS_SW	Character(1)	VARCHAR2(1) NOT NULL	Joint Venture Processing Y/N Table Edit Default Value: N
20	GROUP_PROC_SW	Character(1)	VARCHAR2(1) NOT NULL	Group Asset Processing Y/N Table Edit Default Value: N
21	INFL_ADJ_SW	Character(1)	VARCHAR2(1) NOT NULL	Inflation Processing N=No Y=Yes Default Value: N
22	ACCT_ENT_TMPL_ID	Character(10)	VARCHAR2(10) NOT NULL	Account Entry Template ID Prompt Table: AMAE_TMPLID_VW
23	CHILD_TK_PARENT_SW	Character(1)	VARCHAR2(1) NOT NULL	Child Inherits Parent's Life Y/N Table Edit Default Value: N
24	ARCHIVE_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID
25	ACCUM_DEPR	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Accumulated Depreciation
26	NET_BK_VALUE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Net Book Value
27	DEPR_CUR	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Current Period Depreciation
28	CURRENT_FY_PDP	Character(1)	VARCHAR2(1) NOT NULL	Current FY PDP for Reglr Asset Y/N Table Edit Default Value: Y
29	CURRENT_FY_PDP_GRP	Character(1)	VARCHAR2(1) NOT NULL	Current FY PDP for Grp Asset Y/N Table Edit Default Value: Y
30	IMPAIR_FLG	Character(1)	VARCHAR2(1) NOT NULL	Impairment Process Y/N Table Edit Default Value: N
31	IMP_ZERO_COST_ROWS	Character(1)	VARCHAR2(1) NOT NULL	Copy Zero Impair/Revalue Rows Y/N Table Edit Default Value: Y
32	LAST_CNTRCT_NO	Character(5)	VARCHAR2(5) NOT NULL	Contract Number
33	BATCH_LIMIT	Number(9,0)	DECIMAL(9) NOT NULL	Batch Threshold limit Default Value: 100
34	SPACE_MGMT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Space Management Installed Y/N Table Edit Default Value: N
35	IT	Character(1)	VARCHAR2(1) NOT NULL	IT Asset Management Installed Y/N Table Edit Default Value: N
36	FILE_SIZE	Number(10,0)	DECIMAL(10) NOT NULL	File Size for chunking (MB) Default Value: 8
37	DISCO_REQ_TIMEOUT	Number(3,0)	SMALLINT NOT NULL	Discovery Request Timeout(Sec) Default Value: 300
38	EFFECTIVE_RATE_SW	Character(1)	VARCHAR2(1) NOT NULL	Effective Rate Processing Y/N Table Edit Default Value: N
39	NEG_DEPR_SW	Character(1)	VARCHAR2(1) NOT NULL	Stop Depr when NBV < Salvage Y/N Table Edit Default Value: N
40	REVALUE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Revaluation Process Y/N Table Edit Default Value: Y
41	ARM_SRC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Source Device Groups from ARM N=No Y=Yes Y/N Table Edit Default Value: Y
42	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
43	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. Prompt Table: RT_TYPE_TBL
44	FIN_IMPACT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Financial Impact Flag Y/N Table Edit Default Value: N
45	TXN_CURR_SW	Character(1)	VARCHAR2(1) NOT NULL	Trans Currency Translation Y/N Table Edit Default Value: Y
46	CAP_THRSHLD_SW	Character(1)	VARCHAR2(1) NOT NULL	Cap Threshold Processing Y/N Table Edit Default Value: N
47	LAST_INSTANCE_TMP	Number(16,0)	DECIMAL(16) NOT NULL	Last Instance Temp
48	ARO_SW	Character(1)	VARCHAR2(1) NOT NULL	Asset Retirement Obligations N=No Y=Yes
49	TYPE_ACCRETION	Character(3)	VARCHAR2(3) NOT NULL	Accretion Expense
50	PCCF_PASSTHRU_SW	Character(1)	VARCHAR2(1) NOT NULL	Project Chartfield Detail A=Project ID through Activity ID N=Project ID Only Y=Retain All Default Value: N
51	EXP_DEC_POS	Number(2,0)	SMALLINT NOT NULL	Exponential Decimal Positions
52	TYPE_PLEASE_PAY	Character(3)	VARCHAR2(3) NOT NULL	Prior Lease Payment
53	AM_FED_FUND_ATTR	Character(15)	VARCHAR2(15) NOT NULL	Federal Fund Attribute
54	SCAN_BY_FIELD	Character(1)	VARCHAR2(1) NOT NULL	Scan By Field B=Tag Number or Serial ID S=Serial ID Only T=Tag Number Only
55	SCAN_BY_DEFAULT	Character(1)	VARCHAR2(1) NOT NULL	Scan By Default S=Serial ID T=Tag Number