PeopleSoft 9
Asset Management

Table Name PROFILE_CR_TBL

Table Description
PROFILE_CR_TBL
Columns
Name Datatype Is PK Is FK
SETID char(5) Yes Yes
PROFILE_ID char(10) Yes Yes
BOOK char(10) Yes Yes
EFFDT PSDATE Yes No
TAX_CREDIT_TYPE char(1) Yes No
TAX_CREDIT_CD char(6) Yes No
BASIS_RED_OPT char(1) No No
QUAL_INV_CD char(1) No No
TAX_CR_STATUS char(1) No No
Index
Name Type Unique Member
PS_PROFILE_CR_TBL PK Yes
Member(s) of "PS_PROFILE_CR_TBL" Index
SETID
PROFILE_ID
BOOK
EFFDT
TAX_CREDIT_TYPE
TAX_CREDIT_CD

Published December 16, 2006