FACILITYPrompt Table: TRN_T_PHONES_VW
Prompt Table: TRN_T_PHONES_VW
Prompt Table: TRN_T_PHONES_VW
Y/N Table Edit
TRN_T_FACIL_ESP(SQL Table) |
Index Back |
|---|---|
FT Training Facility DataTripartite Foundation. This record contains specific data related with FT. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FACILITY |
Character(6) | VARCHAR2(6) NOT NULL | Facility |
| 2 | PHONE1 | Character(24) | VARCHAR2(24) NOT NULL |
Phone number field for discounts and perks eligibility file.
Prompt Table: TRN_T_PHONES_VW |
| 3 | PHONE2 | Character(24) | VARCHAR2(24) NOT NULL |
Phone number field for discounts and perks eligibility file.
Prompt Table: TRN_T_PHONES_VW |
| 4 | FAX | Character(24) | VARCHAR2(24) NOT NULL |
Fax Number
Prompt Table: TRN_T_PHONES_VW |
| 5 | EMAIL_ADDR | Character(70) | VARCHAR2(70) NOT NULL | Email Address |
| 6 | MAIL_POSTAL_ESP | Character(100) | VARCHAR2(100) NOT NULL | Postal Code |
| 7 | TRN_T_FAC_TYPE_ESP | Character(1) | VARCHAR2(1) NOT NULL |
Facility Type
Y/N Table Edit |
| 8 | FISCAL_ID_CD | Character(10) | VARCHAR2(10) NOT NULL | Fiscal Identification Code |
| 9 | ADDRESS100 | Character(100) | VARCHAR2(100) NOT NULL | Address 1 |
| 10 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 11 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |