FCLTY_ATTR_IDPrompt Table: FCLTY_MEMO_ATTR
1=Number
2=Date
3=Text
4=Signed Number
5=Long
Prompt Table: PSRECDEFN
FCLTY_MEMO_ATTR(SQL Table) |
Index Back |
|---|---|
Facility Attributes TableFacilities Attribute Codes |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FCLTY_ATTR_ID |
Character(5) | VARCHAR2(5) NOT NULL |
A unique key identifier that represents a user defined attribute associated with a counterparty
Prompt Table: FCLTY_MEMO_ATTR |
| 2 | FCLTY_ATTR_DESCR | Character(15) | VARCHAR2(15) NOT NULL | The description for a user defined facility attribute. |
| 3 | FCLTY_ATTR_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
A type attribute that describes the specific purpose of a given counterparty facility attrib
1=Number 2=Date 3=Text 4=Signed Number 5=Long |
| 4 | PROMPT_TBL | Character(15) | VARCHAR2(15) NOT NULL |
Prompt Table
Prompt Table: PSRECDEFN |