GP_ABS_LVDN_PI (SQL Table)	Index Back
Leave Donations PI Table Stores the PI entries generated from the Leave Donations Process

GP_ABS_LVDN_PI

(SQL Table)

Leave Donations PI Table

Stores the PI entries generated from the Leave Donations Process

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TRANSACTION_NBR Number(15,0) DECIMAL(15) NOT NULL 08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size.

2 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

3 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id

4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: GP_EMP_SEC_VW

5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
Prompt Table: EMPLMT_SRCH_GBL

6 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
Prompt Table: %GP_EDIT_FLD1

7 INSTANCE Number(3,0) SMALLINT NOT NULL Instance Number

8 BGN_DT Date(10) DATE Begin Date

9 END_DT Date(10) DATE end date

10 BAL_ADJ Signed Number(20,6) DECIMAL(18,6) NOT NULL Balance Adjustment

11 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

12 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TRANSACTION_NBR	Number(15,0)	DECIMAL(15) NOT NULL	08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size.
2	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
3	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: GP_EMP_SEC_VW
5	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record Prompt Table: EMPLMT_SRCH_GBL
6	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number Prompt Table: %GP_EDIT_FLD1
7	INSTANCE	Number(3,0)	SMALLINT NOT NULL	Instance Number
8	BGN_DT	Date(10)	DATE	Begin Date
9	END_DT	Date(10)	DATE	end date
10	BAL_ADJ	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Balance Adjustment
11	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
12	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.