GPIT_S503_TMP_C

(SQL Table)
Index Back

S503 Temporary record

Record for S503 report

# 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 GPIT_PAY_PRD_ENDDT Date(10) DATE Pay Period End Date of Event
6 TAKE_CONFIG2 Character(10) VARCHAR2(10) NOT NULL Field reserved for custom attribution to an Absence Take
7 ABS_BGN_DT Date(10) DATE Absence Begin Date
8 GPIT_S503_B_ROW_N Number(2,0) SMALLINT NOT NULL Row number for S503 Square B
9 TAKE_CONFIG1 Character(10) VARCHAR2(10) NOT NULL Field reserved for custom attribution to an Absence Take
10 GPIT_MAT_PCT Number(6,2) DECIMAL(5,2) NOT NULL Maternity INPS Percentage
11 GPIT_GG_INPS Number(2,0) SMALLINT NOT NULL INPS days for reports
12 GPIT_DAYS_NOPAY Number(2,0) SMALLINT NOT NULL Field useful in the Previdential CUD Report which contains the value of the INPS Days without payment
13 BEGIN_DT Date(10) DATE Begin Date
14 END_DT Date(10) DATE end date
15 GPIT_SS_PAYMNT Number(19,6) DECIMAL(18,6) NOT NULL Social Secutiy Payment
16 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code