PeopleSoft 9.0
Cash Management

Table Name FCLTY_DFN

Table Description
FCLTY_DFN
Columns
Name Datatype Is PK Is FK
SETID char(5) Yes Yes
FCLTY_ID CHAR(12) Yes No
EFFDT PSDATE Yes No
EFF_STATUS CHAR(1) No No
DESCR CHAR(30) No No
FCLTY_TYPE CHAR(1) No No
REVIEW_DT PSDATE No No
EXPIRATION_DT PSDATE No No
BANK_CD CHAR(5) No Yes
REVIEW_STATUS CHAR(1) No No
ISSUER_CD CHAR(5) No No
GUARANTOR_CD CHAR(5) No No
FACILITY_TYPE CHAR(1) No No
AMOUNT DECIMAL(26,3) No No
CURRENCY_CD CHAR(3) No No
AMOUNT_2 DECIMAL(26,3) No No
FCLTY_COMMIT_FLG CHAR(1) No No
FCLTY_REVOLVE_FLG CHAR(1) No No
FCLTY_CONVERT_FLG CHAR(1) No No
FCLTY_CPBACKUP_FLG CHAR(1) No No
TRANSACTION_RATE DECIMAL(15,8) No No
FCLTY_CMTFEE_CLC CHAR(1) No No
REPEAT_INTERVAL CHAR(3) No No
AMOUNT_3 DECIMAL(26,3) No No
FLOATING_MKT_CD CHAR(10) No No
INT_BASIS CHAR(2) No No
FLOATING_MARGIN DECIMAL(11,8) No No
TRANSACTION_RATE_2 DECIMAL(15,8) No No
RESET_INDEX_TENOR CHAR(3) No No
FLT_MARGIN_OP CHAR(1) No No
RT_TYPE CHAR(5) No No
Index
Name Type Unique Member
PS_FCLTY_DFN PK Yes
Member(s) of "PS_FCLTY_DFN" Index
SETID
FCLTY_ID
EFFDT

Published April 30, 2007