GPCN_PHFSI_AET

(SQL Table)
Index Back

Tax report State Record

Tax report State Record.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
4 PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
5 GP_RPT_ID Character(18) VARCHAR2(18) NOT NULL Extraction Process Name
6 GPCN_MONTHCD Character(2) VARCHAR2(2) NOT NULL Month Code (along with translate values)
01=January
02=February
03=March
04=April
05=May
06=June
07=July
08=August
09=September
10=October
11=November
12=December
7 GPCN_YEARCD Character(4) VARCHAR2(4) NOT NULL Year Code (along with translate values)
8 GPCN_RECREATE Character(1) VARCHAR2(1) NOT NULL Recreate

Y/N Table Edit

Default Value: N

9 BGN_DT Date(10) DATE Begin Date
10 END_DT Date(10) DATE end date
11 GPCN_CONTRIB_AREA Character(30) VARCHAR2(30) NOT NULL Contribution Area

Prompt Table: GPCN_CONT_AR_VW

12 GPCN_CONTRIB_TYPE Character(20) VARCHAR2(20) NOT NULL Contribution Type

Prompt Table: GPCN_CONT_TP_VW