RUN_FGSF75(SQL Table) |
Index Back |
---|---|
Run Control to print SF75Run Control to print SF75 |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL |
Run Control ID
Prompt Table: PRCSRUNCNTL |
3 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON_NAME |
4 | REQUEST_DT | Date(10) | DATE |
Request Date
Default Value: %date |
5 | GVT_INFO_EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
GVT Information Employee ID
Prompt Table: PERSON_NAME |
6 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
7 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | Telephone |
8 | JOBTITLE | Character(30) | VARCHAR2(30) NOT NULL | Job Title |
9 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
10 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
11 | ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
12 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
13 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
14 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
15 | ADDRESS1_OTHER | Character(55) | VARCHAR2(55) NOT NULL | Address 1 Other |
16 | ADDRESS2_OTHER | Character(55) | VARCHAR2(55) NOT NULL | Address 2 Other |
17 | ADDRESS3_OTHER | Character(55) | VARCHAR2(55) NOT NULL | Address 3 Other |
18 | CITY_OTHER | Character(30) | VARCHAR2(30) NOT NULL | City Other |
19 | STATE_OTHER | Character(6) | VARCHAR2(6) NOT NULL | State Other |
20 | POSTAL_OTHER | Character(12) | VARCHAR2(12) NOT NULL | Postal Other |
21 | GVT_TO_NAME | Character(40) | VARCHAR2(40) NOT NULL | GVT to Name |
22 | GVT_TO_TITLE | Character(30) | VARCHAR2(30) NOT NULL | GVT To Title |
23 | DESCRLONG | Long Character | CLOB | Long Description |