AM_FDRL_RUL1_VW

(SQL View)
 Index Back

AM Federal Asset Rule Detail


SELECT DISTINCT H.SETID , H.AM_FDRL_RULE , H.EFFDT , D.CATEGORY , D.LINE_NBR , H.DESCR , H.EFF_STATUS , D.TRANS_TYPE , D.DISTRIBUTION_TYPE , D.TRANS_IN_OUT , D.ACCOUNT , D.ACCOUNT_SIGN , D.SIGN_ADJUSTER FROM PS_AM_FDRL_RUL_HDR H , PS_AM_FDRL_RUL_DTL D WHERE H.SETID = D.SETID AND H.AM_FDRL_RULE = D.AM_FDRL_RULE AND H.EFFDT = D.EFFDT AND D.ACCOUNT <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 AM_FDRL_RULE Character(10) VARCHAR2(10) NOT NULL AM Federal Asset Rules field
3 EFFDT Date(10) DATE NOT NULL Effective Date
4 CATEGORY Character(5) VARCHAR2(5) NOT NULL Asset Category

Prompt Table: CATEGORY_TBL

5 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
7 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
8 TRANS_TYPE Character(3) VARCHAR2(3) NOT NULL Types of Asset Management Transactions
ACR=Accretion Expense
ADD=Asset Addition
ADJ=Asset Cost Adjustment
BKS=Book Adjustment
BUD=Budgeted Depreciation
DPR=Depreciation
INF=Inflation Adjustment
LEX=Lease Expense
LPB=Budgeted Lease Payments
LPY=Lease Payment
PDP=Prior Period Depreciation
PLP=Prior Lease Payment
RAD=Manual Reserve Adjustment
RCT=Asset Recategorization
REI=Asset Reinstatement
RES=Resume Depreciation
RET=Asset Retirement
RRC=Retro rate change for grp ast
SUS=Suspend Depreciation
TRF=Asset Transfer
9 DISTRIBUTION_TYPE Character(2) VARCHAR2(2) NOT NULL Distribution Type
10 TRANS_IN_OUT Character(1) VARCHAR2(1) NOT NULL Transaction In/Out
I=In
M=IUT Proceeds Markup
O=Out
11 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
12 ACCOUNT_SIGN Signed Number(2,0) DECIMAL(1) NOT NULL Account Sign
13 SIGN_ADJUSTER Signed Number(2,0) DECIMAL(1) NOT NULL Used to adjust sign for AM trn