BOOK_HIST_STAGE (SQL Table)	Index Back
Financial Book History Updates Book_Hist table as part of Online Transaction reversal, Added new sub record: Book_Hist_Extn to include fields in Book table and not in Book_Hist table

BOOK_HIST_STAGE

(SQL Table)

Financial Book History

Updates Book_Hist table as part of Online Transaction reversal, Added new sub record: Book_Hist_Extn to include fields in Book table and not in Book_Hist table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_AM_NONVW

2 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

3 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name
Prompt Table: SP_BU_BK_NONVW

4 DTTM_STAMP DateTime(26) TIMESTAMP 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.

5 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID

6 AM_TRANS_SOURCE Character(3) VARCHAR2(3) NOT NULL Differentiate data source for transaction staging tables.
AWF=AM Workflow

7 BOOK_CHANGE_TYPE Character(3) VARCHAR2(3) NOT NULL Book Change Type
ADD=Add
LFE=Life Ext.
MTH=Method
MUL=Multi Chng
OTH=Other
RCL=Recalc
RES=Resume
RRC=Rate Change
SUS=Suspend
TRF=Transfer

8 TRANS_DT Date(10) DATE Transaction Date

9 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

10 IN_SERVICE_DT Date(10) DATE In Service Date

11 DEPR_IN_SERVICE_SW Character(1) VARCHAR2(1) NOT NULL Depreciate When In Service
N=No
X=Used to be set to 'Y'
Y=Yes
Default Value: N

12 DEPR_CALC_SW Character(1) VARCHAR2(1) NOT NULL Depreciation Calculation Sw

13 CALCULATION_TYPE Character(1) VARCHAR2(1) NOT NULL Calculation Type
L=Life-to-Date
R=Remaining Value
Default Value: R

14 DEPR_STATUS Character(1) VARCHAR2(1) NOT NULL Depreciation Status
D=Depreciable
N=Non Depreciable

15 CONVENTION Character(2) VARCHAR2(2) NOT NULL Book Depreciation Convention or Cost Convention
Prompt Table: CONV_BOOK_VW

16 LIFE Number(4,0) SMALLINT NOT NULL Useful Life

17 DEPR_PERCENT Number(10,8) DECIMAL(9,8) NOT NULL Depreciation Percent

18 DB_PERCENT Number(16,14) DECIMAL(15,14) NOT NULL Declining Balance Percent

19 METHOD Character(2) VARCHAR2(2) NOT NULL Method
DL=DB w/SL By Limit%
DX=Declining Balance w/SL
F1=France Derogatory Balance
FL=Flat Rate %
G1=Germany Staffel Method
J1=Japan- Tangible/Declining Bal
J2=Japan- Tangible/Strt Line
J3=Japan- Intangible/Strt Line
J4=Japan - Lease Depreciation
J5=Japan-Changes DB to SL
J6=Japan - Changes DB to SL 250
J7=Japan-Tangible/Strt Line Rev
J8=Japan - Changes DB to SL 200
J9=JPN - Changes 200/250 DB to SL
JE=Japan - Extended/Strt Line
MN=Manual Depreciation
PC=Declining Balance
SC=Depreciation Schedule
SL=Straight Line
SP=Straight Line Percent
SY=Sum of the Years
UD=User Defined Method
UP=Units of Production

20 DEPR_SCHED_CD Character(10) VARCHAR2(10) NOT NULL Schedule Code
Prompt Table: DEPR_SCHED_TBL

21 DEPR_LIMIT_CD Character(10) VARCHAR2(10) NOT NULL Depreciation Limit Code
Prompt Table: DEPR_LIM_TBL

22 LIFE_END_DT Date(10) DATE Useful Life End Date

23 DEPR_LOW_LIMIT Signed Number(28,3) DECIMAL(26,3) NOT NULL Depr Low Limit Amount

24 SUSPEND_STATUS Character(1) VARCHAR2(1) NOT NULL Suspend Status
N=Depreciation Has Been Resumed
Y=Depreciation Is Suspended

25 SUSPEND_DT Date(10) DATE Suspend Date

26 RESUME_DT Date(10) DATE Resume Date

27 SUSPENDED_PERIODS Number(4,0) SMALLINT NOT NULL Number of Suspended Periods

28 COST_BASIS_LIMIT Signed Number(28,3) DECIMAL(26,3) NOT NULL Cost Basis Limit

29 DEPR_AVG_OPTION Character(1) VARCHAR2(1) NOT NULL Depreciation Averaging Option
M=Monthly Averaging
N=No Averaging
Y=Yearly Averaging
Default Value: N

30 UOP_ID Character(10) VARCHAR2(10) NOT NULL Units of Production ID
Prompt Table: UOP_TBL

31 GROUP_ASSET_ID Character(12) VARCHAR2(12) NOT NULL Group Asset ID
Prompt Table: BK_GRP_ASSET_VW

32 UD_METHOD_ID Character(5) VARCHAR2(5) NOT NULL Method ID
Prompt Table: UD_METHOD

33 PERIOD_DEPR_SW Character(1) VARCHAR2(1) NOT NULL Depreciate By Period
Y/N Table Edit
Default Value: N

34 DEPR_PASS_LIFE_SW Character(1) VARCHAR2(1) NOT NULL Depreciate Pass Life SW
Y/N Table Edit
Default Value: N

35 DEPR_LIMIT_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Depreciation Limit Percent

36 MULTI_SHIFT_CODE Character(6) VARCHAR2(6) NOT NULL Multi_Shift Code is used to assign and specify the Multi_Shift factor. A Multi_Shift factor is used to indicate the % of increase of annual depreciation during a multi_shift operation. For example a shift factor of 50% means there will be a 50% increase of the annual depreciation.
Prompt Table: MULTI_SHIFT_TBL

37 MULTI_SHIFT_NBR Number(1,0) SMALLINT NOT NULL This field is used to indicate the number of shifts operated within a fiscal year during a multi-shift operation.

38 ACCOUNTING_MTHD Character(3) VARCHAR2(3) NOT NULL Accounting Method
ALL=Allowance
EXP=Expense
RES=Reserve

39 SPECIAL_TERMS Character(10) VARCHAR2(10) NOT NULL Special Terms
Prompt Table: DEPR_TERMS_TBL

40 ACCELERATED_TERMS Character(10) VARCHAR2(10) NOT NULL Accelerated Terms
Prompt Table: DEPR_TERMS_TBL

41 INITIAL_TERMS Character(10) VARCHAR2(10) NOT NULL Initial Terms
Prompt Table: DEPR_TERMS_TBL

42 INCREASE_RATE Signed Number(11,6) DECIMAL(9,6) NOT NULL Increased Rate

43 SPECIAL_DEPR_SW Character(1) VARCHAR2(1) NOT NULL Special Depreciation
Y/N Table Edit
Default Value: N

44 LIFE_IN_YRS Number(6,1) DECIMAL(5,1) NOT NULL Life in Years

45 RETIREMENT_DT Date(10) DATE Projected Retirement Date

46 YEAR_CHANGE Number(4,0) SMALLINT NOT NULL Year of change

47 LOW_VALUE_SW Character(1) VARCHAR2(1) NOT NULL Low Value Asset Only
Y/N Table Edit
Default Value: N

48 BUSINESS_TAX_FLG Character(1) VARCHAR2(1) NOT NULL Business Tax
Default Value: N

49 BUSINESS_TAX_BASIS Signed Number(28,3) DECIMAL(26,3) NOT NULL Business Tax Basis

50 DEROGATORY_SW Character(1) VARCHAR2(1) NOT NULL Derogatory Depreciation
Y/N Table Edit
Default Value: N

51 CCA_50_FLG Character(1) VARCHAR2(1) NOT NULL g

52 FUTURE_DEPR_YEARS Number(3,0) SMALLINT NOT NULL No of Future Depreciation Year

53 BEGIN_DEPR_DT Date(10) DATE Begin Depr Date

54 BEGIN_FRACTION Signed Number(17,13) DECIMAL(15,13) NOT NULL Begin Depr Period Fraction

55 RSV_FRACTION Signed Number(17,13) DECIMAL(15,13) NOT NULL Reserve Fraction (RSV/Cost)

56 SCHED_FRACTION Signed Number(17,13) DECIMAL(15,13) NOT NULL Fraction of Schedule Elapsed

57 YEAR_REM_FRACTION Signed Number(17,13) DECIMAL(15,13) NOT NULL Year Remaining Fraction

58 LIFE_REMAINING Signed Number(17,11) DECIMAL(15,11) NOT NULL Remaining Life

59 SALVAGE_VAL Signed Number(28,3) DECIMAL(26,3) NOT NULL Salvage Value

60 SALVAGE_PCT Number(16,14) DECIMAL(15,14) NOT NULL Salvage Percentage

61 BASIS_RED_TOTAL Signed Number(28,3) DECIMAL(26,3) NOT NULL Credit Basis Reduction Total

62 BASIS_RED_RECAP Signed Number(28,3) DECIMAL(26,3) NOT NULL Basis Reduction Recapture

63 SEC179_TAKEN_SW Character(1) VARCHAR2(1) NOT NULL Section 179 Taken switch
N=Section 179 Expense not taken
Y=Section 179 Expense Taken
Default Value: N

64 SEC179_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Section 179 Taken Amount

65 INCLUDE_CAP_GAINS Character(1) VARCHAR2(1) NOT NULL CGT Applicable
Y/N Table Edit
Default Value: Y

66 BUS_USE_PERCENT Number(10,8) DECIMAL(9,8) NOT NULL Business Use %

67 SEC_291 Character(1) VARCHAR2(1) NOT NULL Corporation Sec.291
N=Not Corporation Sec291
Y=Corporation Sec291

68 END_DEPR_DT Date(10) DATE End Depreciation Date

69 DEPR_BONUS_SW Character(3) VARCHAR2(3) NOT NULL Resolution Date Description -------------- ------- ------------------ 753343 03/13/08 New depreciation bonus:Stimulus Act is added.
0=None
1=Section 101 - Federal
2=New York Liberty Zone
3=Section 101 - Local
4=Gulf Opportunity Zone
5=Stimulus Act
6=American Recovery&Reinvestment
Default Value: 0
Prompt Table: AM_DEPR_BONUS

70 DEPR_BONUS_PCT Number(6,2) DECIMAL(5,2) NOT NULL Depreciation Bonus Percent

71 IMPAIR_FLG Character(1) VARCHAR2(1) NOT NULL Impairment Process

72 FULLY_DEPR_SW Character(1) VARCHAR2(1) NOT NULL Retire As Fully Depreciated SW
F=Fully Depr with Future Expense
N=Calculate Gain/Loss
Y=Fully Depr no Future Expense
Default Value: N

73 BK_CAP_THRSHLD_ID Character(10) VARCHAR2(10) NOT NULL Threshold ID
Prompt Table: CAP_THR_DFN2_VW

74 AM_CAP_STATUS_SW Character(1) VARCHAR2(1) NOT NULL Physical Book Cost
Y/N Table Edit
Default Value: Y

75 TRANS_REV_SW Character(1) VARCHAR2(1) NOT NULL 3/10/2015 If Switch has a value 'Y' it denotes that BKS transaction can be reversed. This is important as we are adding new fields to BOOK_HIST table. Hence BKS cannot be reversed as long as there are atleast two rows in BOOK_HIST with value for newly added fields .

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_AM_NONVW
2	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
3	BOOK	Character(10)	VARCHAR2(10) NOT NULL	Asset Book Name Prompt Table: SP_BU_BK_NONVW
4	DTTM_STAMP	DateTime(26)	TIMESTAMP	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.
5	USERID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
6	AM_TRANS_SOURCE	Character(3)	VARCHAR2(3) NOT NULL	Differentiate data source for transaction staging tables. AWF=AM Workflow
7	BOOK_CHANGE_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Book Change Type ADD=Add LFE=Life Ext. MTH=Method MUL=Multi Chng OTH=Other RCL=Recalc RES=Resume RRC=Rate Change SUS=Suspend TRF=Transfer
8	TRANS_DT	Date(10)	DATE	Transaction Date
9	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
10	IN_SERVICE_DT	Date(10)	DATE	In Service Date
11	DEPR_IN_SERVICE_SW	Character(1)	VARCHAR2(1) NOT NULL	Depreciate When In Service N=No X=Used to be set to 'Y' Y=Yes Default Value: N
12	DEPR_CALC_SW	Character(1)	VARCHAR2(1) NOT NULL	Depreciation Calculation Sw
13	CALCULATION_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Calculation Type L=Life-to-Date R=Remaining Value Default Value: R
14	DEPR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Depreciation Status D=Depreciable N=Non Depreciable
15	CONVENTION	Character(2)	VARCHAR2(2) NOT NULL	Book Depreciation Convention or Cost Convention Prompt Table: CONV_BOOK_VW
16	LIFE	Number(4,0)	SMALLINT NOT NULL	Useful Life
17	DEPR_PERCENT	Number(10,8)	DECIMAL(9,8) NOT NULL	Depreciation Percent
18	DB_PERCENT	Number(16,14)	DECIMAL(15,14) NOT NULL	Declining Balance Percent
19	METHOD	Character(2)	VARCHAR2(2) NOT NULL	Method DL=DB w/SL By Limit% DX=Declining Balance w/SL F1=France Derogatory Balance FL=Flat Rate % G1=Germany Staffel Method J1=Japan- Tangible/Declining Bal J2=Japan- Tangible/Strt Line J3=Japan- Intangible/Strt Line J4=Japan - Lease Depreciation J5=Japan-Changes DB to SL J6=Japan - Changes DB to SL 250 J7=Japan-Tangible/Strt Line Rev J8=Japan - Changes DB to SL 200 J9=JPN - Changes 200/250 DB to SL JE=Japan - Extended/Strt Line MN=Manual Depreciation PC=Declining Balance SC=Depreciation Schedule SL=Straight Line SP=Straight Line Percent SY=Sum of the Years UD=User Defined Method UP=Units of Production
20	DEPR_SCHED_CD	Character(10)	VARCHAR2(10) NOT NULL	Schedule Code Prompt Table: DEPR_SCHED_TBL
21	DEPR_LIMIT_CD	Character(10)	VARCHAR2(10) NOT NULL	Depreciation Limit Code Prompt Table: DEPR_LIM_TBL
22	LIFE_END_DT	Date(10)	DATE	Useful Life End Date
23	DEPR_LOW_LIMIT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Depr Low Limit Amount
24	SUSPEND_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Suspend Status N=Depreciation Has Been Resumed Y=Depreciation Is Suspended
25	SUSPEND_DT	Date(10)	DATE	Suspend Date
26	RESUME_DT	Date(10)	DATE	Resume Date
27	SUSPENDED_PERIODS	Number(4,0)	SMALLINT NOT NULL	Number of Suspended Periods
28	COST_BASIS_LIMIT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Cost Basis Limit
29	DEPR_AVG_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Depreciation Averaging Option M=Monthly Averaging N=No Averaging Y=Yearly Averaging Default Value: N
30	UOP_ID	Character(10)	VARCHAR2(10) NOT NULL	Units of Production ID Prompt Table: UOP_TBL
31	GROUP_ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Group Asset ID Prompt Table: BK_GRP_ASSET_VW
32	UD_METHOD_ID	Character(5)	VARCHAR2(5) NOT NULL	Method ID Prompt Table: UD_METHOD
33	PERIOD_DEPR_SW	Character(1)	VARCHAR2(1) NOT NULL	Depreciate By Period Y/N Table Edit Default Value: N
34	DEPR_PASS_LIFE_SW	Character(1)	VARCHAR2(1) NOT NULL	Depreciate Pass Life SW Y/N Table Edit Default Value: N
35	DEPR_LIMIT_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Depreciation Limit Percent
36	MULTI_SHIFT_CODE	Character(6)	VARCHAR2(6) NOT NULL	Multi_Shift Code is used to assign and specify the Multi_Shift factor. A Multi_Shift factor is used to indicate the % of increase of annual depreciation during a multi_shift operation. For example a shift factor of 50% means there will be a 50% increase of the annual depreciation. Prompt Table: MULTI_SHIFT_TBL
37	MULTI_SHIFT_NBR	Number(1,0)	SMALLINT NOT NULL	This field is used to indicate the number of shifts operated within a fiscal year during a multi-shift operation.
38	ACCOUNTING_MTHD	Character(3)	VARCHAR2(3) NOT NULL	Accounting Method ALL=Allowance EXP=Expense RES=Reserve
39	SPECIAL_TERMS	Character(10)	VARCHAR2(10) NOT NULL	Special Terms Prompt Table: DEPR_TERMS_TBL
40	ACCELERATED_TERMS	Character(10)	VARCHAR2(10) NOT NULL	Accelerated Terms Prompt Table: DEPR_TERMS_TBL
41	INITIAL_TERMS	Character(10)	VARCHAR2(10) NOT NULL	Initial Terms Prompt Table: DEPR_TERMS_TBL
42	INCREASE_RATE	Signed Number(11,6)	DECIMAL(9,6) NOT NULL	Increased Rate
43	SPECIAL_DEPR_SW	Character(1)	VARCHAR2(1) NOT NULL	Special Depreciation Y/N Table Edit Default Value: N
44	LIFE_IN_YRS	Number(6,1)	DECIMAL(5,1) NOT NULL	Life in Years
45	RETIREMENT_DT	Date(10)	DATE	Projected Retirement Date
46	YEAR_CHANGE	Number(4,0)	SMALLINT NOT NULL	Year of change
47	LOW_VALUE_SW	Character(1)	VARCHAR2(1) NOT NULL	Low Value Asset Only Y/N Table Edit Default Value: N
48	BUSINESS_TAX_FLG	Character(1)	VARCHAR2(1) NOT NULL	Business Tax Default Value: N
49	BUSINESS_TAX_BASIS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Business Tax Basis
50	DEROGATORY_SW	Character(1)	VARCHAR2(1) NOT NULL	Derogatory Depreciation Y/N Table Edit Default Value: N
51	CCA_50_FLG	Character(1)	VARCHAR2(1) NOT NULL	g
52	FUTURE_DEPR_YEARS	Number(3,0)	SMALLINT NOT NULL	No of Future Depreciation Year
53	BEGIN_DEPR_DT	Date(10)	DATE	Begin Depr Date
54	BEGIN_FRACTION	Signed Number(17,13)	DECIMAL(15,13) NOT NULL	Begin Depr Period Fraction
55	RSV_FRACTION	Signed Number(17,13)	DECIMAL(15,13) NOT NULL	Reserve Fraction (RSV/Cost)
56	SCHED_FRACTION	Signed Number(17,13)	DECIMAL(15,13) NOT NULL	Fraction of Schedule Elapsed
57	YEAR_REM_FRACTION	Signed Number(17,13)	DECIMAL(15,13) NOT NULL	Year Remaining Fraction
58	LIFE_REMAINING	Signed Number(17,11)	DECIMAL(15,11) NOT NULL	Remaining Life
59	SALVAGE_VAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Salvage Value
60	SALVAGE_PCT	Number(16,14)	DECIMAL(15,14) NOT NULL	Salvage Percentage
61	BASIS_RED_TOTAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Credit Basis Reduction Total
62	BASIS_RED_RECAP	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Basis Reduction Recapture
63	SEC179_TAKEN_SW	Character(1)	VARCHAR2(1) NOT NULL	Section 179 Taken switch N=Section 179 Expense not taken Y=Section 179 Expense Taken Default Value: N
64	SEC179_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Section 179 Taken Amount
65	INCLUDE_CAP_GAINS	Character(1)	VARCHAR2(1) NOT NULL	CGT Applicable Y/N Table Edit Default Value: Y
66	BUS_USE_PERCENT	Number(10,8)	DECIMAL(9,8) NOT NULL	Business Use %
67	SEC_291	Character(1)	VARCHAR2(1) NOT NULL	Corporation Sec.291 N=Not Corporation Sec291 Y=Corporation Sec291
68	END_DEPR_DT	Date(10)	DATE	End Depreciation Date
69	DEPR_BONUS_SW	Character(3)	VARCHAR2(3) NOT NULL	Resolution Date Description -------------- ------- ------------------ 753343 03/13/08 New depreciation bonus:Stimulus Act is added. 0=None 1=Section 101 - Federal 2=New York Liberty Zone 3=Section 101 - Local 4=Gulf Opportunity Zone 5=Stimulus Act 6=American Recovery&Reinvestment Default Value: 0 Prompt Table: AM_DEPR_BONUS
70	DEPR_BONUS_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Depreciation Bonus Percent
71	IMPAIR_FLG	Character(1)	VARCHAR2(1) NOT NULL	Impairment Process
72	FULLY_DEPR_SW	Character(1)	VARCHAR2(1) NOT NULL	Retire As Fully Depreciated SW F=Fully Depr with Future Expense N=Calculate Gain/Loss Y=Fully Depr no Future Expense Default Value: N
73	BK_CAP_THRSHLD_ID	Character(10)	VARCHAR2(10) NOT NULL	Threshold ID Prompt Table: CAP_THR_DFN2_VW
74	AM_CAP_STATUS_SW	Character(1)	VARCHAR2(1) NOT NULL	Physical Book Cost Y/N Table Edit Default Value: Y
75	TRANS_REV_SW	Character(1)	VARCHAR2(1) NOT NULL	3/10/2015 If Switch has a value 'Y' it denotes that BKS transaction can be reversed. This is important as we are adding new fields to BOOK_HIST table. Hence BKS cannot be reversed as long as there are atleast two rows in BOOK_HIST with value for newly added fields .