PV_EASYFORM_TYPEPV_EASYFORM_IDUSSS=US Services
USST=US Standard
Default Value: USST
Prompt Table: COUNTRY_TBL
Prompt Table: STATE_TBL
1000=1000
250=250
500=500
PV_BUSCARD_INFO(SQL Table) |
Index Back |
|---|---|
Business Card Info8/30/07 - JK - Added Record Description. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PV_EASYFORM_TYPE |
Character(10) | VARCHAR2(10) NOT NULL | Easyform Type |
| 2 | PV_EASYFORM_ID |
Character(10) | VARCHAR2(10) NOT NULL | Easyform ID |
| 3 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 4 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 5 | PV_BCSTYL_ID | Character(4) | VARCHAR2(4) NOT NULL |
Business Card Style ID
USSS=US Services USST=US Standard Default Value: USST |
| 6 | PV_NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 7 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 8 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 9 | PV_DIVISION | Character(20) | VARCHAR2(20) NOT NULL | DIVISION |
| 10 | PV_EMAIL | Character(30) | VARCHAR2(30) NOT NULL | Submitted By |
| 11 | PV_PHONE1 | Character(24) | VARCHAR2(24) NOT NULL | Telephone |
| 12 | PV_PHONE2 | Character(24) | VARCHAR2(24) NOT NULL | Telephone |
| 13 | PV_PHONE3 | Character(24) | VARCHAR2(24) NOT NULL | Telephone |
| 14 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 15 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: STATE_TBL |
| 16 | TITLE | Character(35) | VARCHAR2(35) NOT NULL | Title |
| 17 | URL | Character(254) | VARCHAR2(254) NOT NULL | Internet URL (Universal Resource Locator) |
| 18 | ZIP | Character(10) | VARCHAR2(10) NOT NULL | Postal Code |
| 19 | PV_BUSCARD_QTY | Character(4) | VARCHAR2(4) NOT NULL |
Business Card Quantity
1000=1000 250=250 500=500 |