FIELDNAMEHCI_FIELD(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 2 | HCI_FIELDTYPE | Character(14) | VARCHAR2(14) NOT NULL | Field type |
| 3 | HCI_IS_KEY | Character(1) | VARCHAR2(1) NOT NULL | Is Key yes / no |
| 4 | HCI_FIELDVALUE | Character(250) | VARCHAR2(250) NOT NULL | Field Value converted to character string |