GPIT_GV93_TMP_A

(SQL Table)
Index Back

GV93 table for AE

GV93 table for AE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
5 INPDAI_CODE_ITA Character(16) VARCHAR2(16) NOT NULL INPDAI Code ITA
6 GPIT_GV93_SEZIONE Character(2) VARCHAR2(2) NOT NULL GV93 Section Field for GV93 report
7 GPIT_GV93_POSIZ Number(3,0) SMALLINT NOT NULL Position in Section Field for GV93 report
8 PIN_MBR_NUM Number(8,0) INTEGER NOT NULL Element number field
9 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
10 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
11 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
12 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
13 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
14 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID
15 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
16 RSLT_VER_NUM Number(4,0) SMALLINT NOT NULL Result Version Number
17 GPIT_GV93_PERSINO Character(1) VARCHAR2(1) NOT NULL Flag Yes/No Period field for GV93 report
18 BEGIN_DT Date(10) DATE Begin Date
19 END_DT Date(10) DATE end date
20 GPIT_GV93_IDECOD Character(4) VARCHAR2(4) NOT NULL GV93 Identification Code Field for GV93 report
21 GPIT_GV93_EL_PBP Number(8,0) INTEGER NOT NULL Period Begin Date Field for GV93 report.
22 GPIT_GV93_EL_PEP Number(8,0) INTEGER NOT NULL Period End Date Field for GV93 report.
23 GPIT_TEMP_AMN_12_2 Number(15,2) DECIMAL(14,2) NOT NULL Amount of temp. var. Field for GV93 report
24 GPIT_SEGNO_1 Character(2) VARCHAR2(2) NOT NULL Add/Subtract Field for reports
+1=Add
-1=Subtract