GPIT_GV93_RUNCL

(SQL Table)
Index Back

GV93 Run Control

GV93 Report Italy...

# 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
4 GPIT_RUN_MONTH Character(2) VARCHAR2(2) NOT NULL A report could be runned on a 3 months period. This field will have the value of the month to be processed.
01=01 - January
02=02 - February
03=03 - March
04=04 - April
05=05 - May
06=06 - June
07=07 - July
08=08 - August
09=09 - September
10=10 - October
11=11 - November
12=12 - December
5 GPIT_YEAR_NUM4 Number(4,0) SMALLINT NOT NULL Year
6 GPIT_PER_BGN_DT1 Date(10) DATE Field to be used as Period Begin Date. Different labels can be inserted for different purposes.
7 GPIT_PER_END_DT1 Date(10) DATE Field to be used as Period Begin Date. Different labels can be inserted for different purposes.
8 GPIT_GV93_RUN_OCC Character(1) VARCHAR2(1) NOT NULL Run Type for GV93. This report could be runned on a month or on 3 months. Depending on the content of this field, the report will consider a different seet of results value.
M=Monthly Run
T=Quarterly Run

Default Value: M

9 GPIT_RUN_QUARTER Character(2) VARCHAR2(2) NOT NULL A report could be runned on a 3 months period. This field will have the value of the final month of the quarter. For example for Jan-Mar period it will have the 03-March value.
03=03 - January-February-March
06=06 - April-May-June
09=09 - July-August-September
12=12 - October-November-December
10 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity

Prompt Table: GP_PYENT

11 GPIT_GV93_CRIT1 Character(1) VARCHAR2(1) NOT NULL 1.Criteria 1
I=INPDAI Company Code
Y=Company

Default Value: I