GVT_NH_RUNCTL

(SQL Table)
Index Back

# 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 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: COMPANY_TBL

4 FILE_NAME Character(80) VARCHAR2(80) NOT NULL File Name
5 GVT_RUN_TYPE Character(1) VARCHAR2(1) NOT NULL Run Type
B=Biweekly
Q=Quarterly
6 GVT_BATCH_NBR Number(6,0) INTEGER NOT NULL Batch Number to Reprocess

Prompt Table: GVT_NH_CONTROL

7 FROM_DATE Date(10) DATE NOT NULL From Date
8 TO_DATE Date(10) DATE NOT NULL Latest Date to be sent to PYR
9 BALANCE_QTR Number(3,0) SMALLINT NOT NULL Balances for Quarter
10 REPROCESS Character(1) VARCHAR2(1) NOT NULL Reprocess?

Y/N Table Edit

Default Value: N