PeopleSoft 9
Asset Management

Table Name PI_CNTL

Table Description
PI_CNTL
Columns
Name Datatype Is PK Is FK
PI_ID char(10) Yes No
PI_NAME char(30) No No
BUSINESS_UNIT char(5) No No
PI_EXT_MC_ID char(30) No No
PI_SCAN_MC_ID char(30) No No
OPRID char(30) No No
ACCOUNTING_DT PSDATE No No
TRANS_DT PSDATE No No
INTFC_ID int No No
OPEN_TRANS_ID decimal(10) No No
TRANS_CODE char(5) No No
DTTM_STAMP PSDATETIME No No
CURRENCY_CD char(3) No No
VOLUNTARY char(1) No No
RETIRE_CONVENTION char(2) No No
RETIREMENT_TYPE char(1) No No
DISPOSAL_CODE char(1) No No
START_DT PSDATE No No
END_DT PSDATE No No
ADD_SW char(1) No No
TRF_SW char(1) No No
RET_SW char(1) No No
PHY_SW char(1) No No
AUP_SW char(1) No No
PI_NULL_DATE PSDATE No No
PI_NULL_DTTM PSTIME No No
APPROVAL_SW char(1) No No
PI_STEP char(1) No No
CYCLE_YR_RULE_IND char(1) No No
MINIMUM_AMT decimal(17,2) No No
PI_RULES_STRICT char(1) No No
CYCLE_YEAR_DFLT smallint No No
LAST_LINE_NUM int No No
Index
Name Type Unique Member
PS_PI_CNTL PK Yes
PS0PI_CNTL IE1 No
Member(s) of "PS_PI_CNTL" Index
PI_ID
Member(s) of "PS0PI_CNTL" Index
PI_NAME
PI_ID

Published December 16, 2006