PROFILE_PCBK_VW

(SQL View)
 Index Back

Asset Book Profile - Current


SELECT P.SetID , P.Profile_ID , P.Book , P.EffDt , P.PAR_CONVENTION_SW , P.PAR_RET_CONV_SW , P.PAR_SALVAGE_VAL_SW , P.PAR_METHOD_SW , P.PAR_LIFE_SW , P.PAR_TAX_CODE_SW , P.PAR_MULTI_SHIFT_SW , P.PAR_DEPR_LIMIT_SW , P.PAR_COST_BASLIM_SW FROM PS_PROFILE_PARC_BK P WHERE P.Effdt = ( SELECT MAX(Q.Effdt) FROM PS_PROFILE_PARC_BK Q WHERE Q.Setid=P.SetID AND Q.Profile_Id = P.Profile_ID AND Q.Book =P.Book)

# 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: BU_BOOK_VW2

4 EFFDT Date(10) DATE Effective Date

Default Value: %date

5 PAR_CONVENTION_SW Character(1) VARCHAR2(1) NOT NULL Copy Convention from Parent?

Y/N Table Edit

6 PAR_RET_CONV_SW Character(1) VARCHAR2(1) NOT NULL Retirement Convention

Y/N Table Edit

7 PAR_SALVAGE_VAL_SW Character(1) VARCHAR2(1) NOT NULL Copy Salvage Value from Parent

Y/N Table Edit

8 PAR_METHOD_SW Character(1) VARCHAR2(1) NOT NULL Copy Method from Parent Asset?

Y/N Table Edit

9 PAR_LIFE_SW Character(1) VARCHAR2(1) NOT NULL Copy Rem Life from Parent?

Y/N Table Edit

10 PAR_TAX_CODE_SW Character(1) VARCHAR2(1) NOT NULL Copy Tax Code from Parent?

Y/N Table Edit

11 PAR_MULTI_SHIFT_SW Character(1) VARCHAR2(1) NOT NULL Multi-Shift Code

Y/N Table Edit

12 PAR_DEPR_LIMIT_SW Character(1) VARCHAR2(1) NOT NULL Copy Depr Limit from Parent?
13 PAR_COST_BASLIM_SW Character(1) VARCHAR2(1) NOT NULL Cost Basis Limit

Y/N Table Edit