GVT_CONFIRM_TBL

(SQL Table)
Index Back

FEDERAL CONFIRM TABLE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: COMPANY_TBL

2 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

Prompt Table: PAYGROUP_TBL

3 PAY_END_DT Date(10) DATE NOT NULL Pay Period End Date
4 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?

Y/N Table Edit

5 GVT_CONFIRM_DT Date(10) DATE Federal Confirm Run Date
6 PAGE_NUM Number(4,0) SMALLINT NOT NULL Page #
7 GVT_TREAS_IND Character(1) VARCHAR2(1) NOT NULL Federal Treasury Trans Ind

Y/N Table Edit

8 GVT_NET_PAY_IND Character(1) VARCHAR2(1) NOT NULL Federal Net Pay Ind

Y/N Table Edit