PROFILE_CR_VW

(SQL View)
 Index Back

Asset Credits Profile View


Select a.Setid, a.Profile_ID, a.Book, a.Effdt, a.Tax_Credit_Type, a.Tax_Credit_Cd, a.Basis_Red_Opt, a.Qual_Inv_Cd, a.Tax_Cr_Status from PS_PROFILE_CR_TBL a where a.effdt = (Select max(b.Effdt) from PS_PROFILE_CR_TBL b where b.Setid = a.Setid and b.Profile_ID = a.Profile_ID and b.Book = a.Book and b.Tax_Credit_Type = a.Tax_Credit_Type)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SETID_TBL

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

Prompt Table: PROFILE_TBL

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

Prompt Table: SP_BOOK_NONVW

4 EFFDT Date(10) DATE Effective Date

Default Value: %date

5 TAX_CREDIT_TYPE Character(1) VARCHAR2(1) NOT NULL Tax Credit Type
E=Energy Tax Credit
I=Regular Investment Tax Credit
R=Rehabilitation Tax Credit
U=User-Defined
6 TAX_CREDIT_CD Character(6) VARCHAR2(6) NOT NULL Tax Credit Code

Prompt Table: TAX_CR_TBL

7 BASIS_RED_OPT Character(1) VARCHAR2(1) NOT NULL Basis Reduction Option
B=Basis Reduction
N=None - No Basis Reduction
P=Percentage Rate Reduction

Prompt Table: TAX_CR_RED_TBL

8 QUAL_INV_CD Character(1) VARCHAR2(1) NOT NULL Qualified Investment Code
A=Accelerated Cost Recovery Sys
D=Asset Depreciation Range
F=Conventional/Facts& Circumstan
G=Guideline
M=Modified Accel Cost Recovery
9 TAX_CR_STATUS Character(1) VARCHAR2(1) NOT NULL Tax Credit Status