| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table:
SP_SETID_NONVW
|
| 2 |
FCLTY_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
A unique key identifier that represents a given counterparty facility.
Prompt Table:
FCLTY_DFN
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %DATE
|
| 4 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 5 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 6 |
FCLTY_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
An attribute that describes the specific purpose of a given counterparty facility.
I=Internal
X=External
Default Value: I
|
| 7 |
REVIEW_DT |
Date(10) |
DATE |
Review Date
|
| 8 |
EXPIRATION_DT |
Date(10) |
DATE |
Expiration Date
|
| 9 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table:
BANK_TR_CPTY_VW
|
| 10 |
REVIEW_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Review Status
P=Pending Review
R=Reviewed
U=Unreviewed
W=Sent to Workflow
Default Value: U
|
| 11 |
ISSUER_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
The paper issuer associated with a given bank/counterparty.
Prompt Table:
BANK_TR_CPTY_VW
|
| 12 |
GUARANTOR_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
The transaction guarantor associated with a given bank/counterparty.
Prompt Table:
BANK_GURANTR_VW
|
| 13 |
FACILITY_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
3/19/2004 RJB Facility Type field for determining LOC, CP, and Other types of Facilities
1=Other Cash Needs
2=Line of Credit
3=Commercial Paper
Default Value: 1
|
| 14 |
AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 15 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 16 |
AMOUNT_2 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount Work Field
|
| 17 |
FCLTY_COMMIT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag for indicating if Line of Credit facility is a committed facility or not
Y/N Table Edit
Default Value: N
|
| 18 |
FCLTY_REVOLVE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to indicate if facility is a revolving one. Commonly referred to as a "Revolver"
Y/N Table Edit
Default Value: N
|
| 19 |
FCLTY_CONVERT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to indicate if facility is convertible. Typically used to indicate if Line of Credit has an option to convert to a loan with fixed term
Y/N Table Edit
Default Value: N
|
| 20 |
FCLTY_CPBACKUP_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to indicate if facility's purpose is to backup a commercial paper program or facility.
Y/N Table Edit
Default Value: N
|
| 21 |
TRANSACTION_RATE |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
The applicable interest rate for a given deal transaction.
|
| 22 |
FCLTY_CMTFEE_CLC |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates if Facility Fee will be charged on full amount of facility or on unused portion of facility
1=Unused Portion of Facility
2=Full Facility
3=No Commitment Fee
Default Value: 3
|
| 23 |
REPEAT_INTERVAL |
Character(3) |
VARCHAR2(3) NOT NULL |
Represents the form of repeating interval (days or months between each Interest payment date)
D01=Daily
D07=Weekly
D28=Every 28 Days
D35=Every 35 Days
D49=Every 49 Days
M01=Monthly
M03=Quarterly
M06=Semi-Annual
M12=Annual
M99=At Maturity
|
| 24 |
AMOUNT_3 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 25 |
FLOATING_MKT_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
The code used as a key for obtaining market rates for interest rates and futures prices.
Prompt Table:
TRX_RT_RESET_CD
|
| 26 |
INT_BASIS |
Character(2) |
VARCHAR2(2) NOT NULL |
Day Count Basis
30=30/360
3E=30E/360
A0=Actual/360
A5=Actual/365
AA=Actual/Actual
|
| 27 |
FLOATING_MARGIN |
Signed Number(13,8) |
DECIMAL(11,8) NOT NULL |
The supplemental interest rate
|
| 28 |
TRANSACTION_RATE_2 |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
The applicable interest rate for the second leg of a given deal transaction.
|
| 29 |
RESET_INDEX_TENOR |
Character(3) |
VARCHAR2(3) NOT NULL |
Tenor (Term) of Reset Rate Index - how long the Interest Rate applies for
D01=Overnight
D07=1 Week
D14=2 Week
D21=21 Day
D28=28 Day
D35=35 Day
D49=49 Day
M01=1 Month
M03=3 Month
M06=6 Month
M12=1 Year
X=Not Applicable
|
| 30 |
FLT_MARGIN_OP |
Character(1) |
VARCHAR2(1) NOT NULL |
1st floating margin operation, +/- or *//
*=Multiply By
+=Add
|
| 31 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Prompt Table:
RT_TYPE_TBL
|
| 32 |
NOTIFY_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Notification Method
1=Notification Framework
2=Workflow
|