PeopleSoft 9
Asset Management

Table Name AMPRFCHG_RQST

Table Description
AMPRFCHG_RQST
Columns
Name Datatype Is PK Is FK
OPRID char(30) Yes No
RUN_CNTL_ID char(30) Yes No
REQUEST_ID char(10) Yes No
PROCESS_FREQUENCY char(1) No No
PROCESS_STATUS char(1) No No
METHOD char(2) No No
DEPR_SCHED_CD char(10) No No
UD_METHOD_ID char(5) No No
DB_PERCENT decimal(15,14) No No
DB_PERCENT_PNL decimal(9,6) No No
DEPR_PERCENT decimal(9,8) No No
UOP_ID char(10) No Yes
SETID char(5) No Yes
SETID1 char(5) No No
PROFILE_ID char(10) No No
PROFILE_ID_ORIG char(10) No No
DESCR char(30) No No
BOOK char(10) No No
EFFDT_OLD PSDATE No No
EFFDT_NEW PSDATE No No
CATEGORY char(5) No No
CONVENTION char(2) No No
RETIRE_CONVENTION char(2) No No
LIFE smallint No No
SALVAGE_VALUE decimal(26,3) No No
CURRENCY_CD char(3) No No
SALVAGE_PCT decimal(15,14) No No
DEPR_LOW_LIMIT decimal(26,3) No No
DEPR_LIMIT_CD char(10) No No
PROF_ACTION char(1) No No
RUN_PB char(1) No No
ADJUST_CONVENTION CHAR(2) No No
Index
Name Type Unique Member
PS_AMPRFCHG_RQST PK Yes
Member(s) of "PS_AMPRFCHG_RQST" Index
OPRID
RUN_CNTL_ID
REQUEST_ID

Published December 16, 2006