SETIDPrompt Table: SP_SETID_NONVW
FCLTY_IDEFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
Y/N Table Edit
Default Value: N
FCLTY_LOCBKP_VW(SQL View) |
Index Back |
|---|---|
Backup Facility for Comm Paperview of backup facilities for commercial paper |
| SELECT SETID , FCLTY_ID , EFFDT , EFF_STATUS , DESCR , FCLTY_CPBACKUP_FLG , TRANSACTION_RATE_2 FROM PS_FCLTY_DFN WHERE FCLTY_CPBACKUP_FLG = 'Y' AND EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_FCLTY_DFN A_ED WHERE SETID = A_ED.SETID AND FCLTY_ID = A_ED.FCLTY_ID AND A_ED.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
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. |
| 3 | EFFDT |
Date(10) | DATE |
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_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 |
| 7 | TRANSACTION_RATE_2 | Number(16,8) | DECIMAL(15,8) NOT NULL | The applicable interest rate for the second leg of a given deal transaction. |