GVT_RUNCTL_NFC

(SQL Table)
Index Back

Federal NFC SINQ Run control

Federal NFC SINQ Import process run control record

# 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
3 GVT_SINQPAR_FLD Character(1) VARCHAR2(1) NOT NULL Personnel Action SINQ

Y/N Table Edit

Default Value: N

4 GVT_SINQPMSO_FLD Character(1) VARCHAR2(1) NOT NULL Position/Jobcode SINQ

Y/N Table Edit

Default Value: N

5 FILEPATH1 Character(127) VARCHAR2(127) NOT NULL File Path and Name (ANZ)
6 FILEPATH2 Character(127) VARCHAR2(127) NOT NULL File Path and Name (ANZ)
7 GVT_NFC_DOC_LIST Character(6) VARCHAR2(6) NOT NULL Federal HRMS

Prompt Table: GVT_NFC_PRO_LST

8 RUN_DT Date(10) DATE Run Date

Default Value: %Date

9 SINQROLE Character(30) VARCHAR2(30) NOT NULL User Notification Role Name

Prompt Table: PSROLEDEFN

10 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).

Prompt Table: PSROLEDEFN

11 URL_1 Character(254) VARCHAR2(254) NOT NULL URL #1
12 URL_2 Character(254) VARCHAR2(254) NOT NULL URL #2
13 URL_3 Character(254) VARCHAR2(254) NOT NULL URL #3
14 URL_4 Character(254) VARCHAR2(254) NOT NULL URL #4