RUN_FGSF75

(SQL Table)
Index Back

Run Control to print SF75

Run 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