GPS_POST_NOTIFY (SQL Table)	Index Back
GPS Post Mngmnt Notifications Geman Public Sector notifications for Post Management.

GPS_POST_NOTIFY

(SQL Table)

GPS Post Mngmnt Notifications

Geman Public Sector notifications for Post Management.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: GPS_MSG_PERS_VW

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

3 EFFDT Date(10) DATE NOT NULL Effective Date

4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

5 GPS_NOTIFIC_SRC Character(4) VARCHAR2(4) NOT NULL Post Management Notification Source
ADP=ADP
HR=Human Resources

6 ACTION Character(3) VARCHAR2(3) NOT NULL Action
Prompt Table: GPS_ADP_ACT_VW

7 BEGIN_DT Date(10) DATE Begin Date
Default Value: %date

8 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code
Prompt Table: ACTN_REASON_TBL

9 RETURN_DT Date(10) DATE Return Date

10 GPS_EF23U2_RPT Signed Number(20,6) DECIMAL(18,6) NOT NULL GPS Report Field: Federation and/or nationalinternal purposes Taxpayer of gross purchases in the report S.A. situation month June, incl. part-time work for elderly people addition and fortune-effective achievements, without Single payments in EUR. Note: To fill out only if EF10 equal 1 to 3, 6 to 9; otherwise Empty.

11 GPS_EF25_RPT Signed Number(20,6) DECIMAL(18,6) NOT NULL GPS Report Field: Fortune-effective achievements -employer portion- in EUR Note: To fill out only if EF10 equal 1 to 3, 7 to 9; otherwise Empty.

12 GPS_EF26_RPT Signed Number(20,6) DECIMAL(18,6) NOT NULL GPS Report Field: General extra pay in EUR Note: To fill out only if EF10 equal 1 to 3, 7 to 9 and EF12 equal 1, 3, 7,8; otherwise empty. Woman officials and an official: Z.B. No. 27 General prefaces to the pay regulations A and B, the BBesG or equivalent National salary laws LBesG, e.g. Bremen No. 12, Thuringia No. 7 exp. 1 or Hamburg 48 HmbBesG.

13 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field

14 GPS_CHECK_FLAG Character(1) VARCHAR2(1) NOT NULL Marked as Read flag.
Y/N Table Edit
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: GPS_MSG_PERS_VW
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date
4	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
5	GPS_NOTIFIC_SRC	Character(4)	VARCHAR2(4) NOT NULL	Post Management Notification Source ADP=ADP HR=Human Resources
6	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action Prompt Table: GPS_ADP_ACT_VW
7	BEGIN_DT	Date(10)	DATE	Begin Date Default Value: %date
8	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code Prompt Table: ACTN_REASON_TBL
9	RETURN_DT	Date(10)	DATE	Return Date
10	GPS_EF23U2_RPT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	GPS Report Field: Federation and/or nationalinternal purposes Taxpayer of gross purchases in the report S.A. situation month June, incl. part-time work for elderly people addition and fortune-effective achievements, without Single payments in EUR. Note: To fill out only if EF10 equal 1 to 3, 6 to 9; otherwise Empty.
11	GPS_EF25_RPT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	GPS Report Field: Fortune-effective achievements -employer portion- in EUR Note: To fill out only if EF10 equal 1 to 3, 7 to 9; otherwise Empty.
12	GPS_EF26_RPT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	GPS Report Field: General extra pay in EUR Note: To fill out only if EF10 equal 1 to 3, 7 to 9 and EF12 equal 1, 3, 7,8; otherwise empty. Woman officials and an official: Z.B. No. 27 General prefaces to the pay regulations A and B, the BBesG or equivalent National salary laws LBesG, e.g. Bremen No. 12, Thuringia No. 7 exp. 1 or Hamburg 48 HmbBesG.
13	PIN_NM	Character(18)	VARCHAR2(18) NOT NULL	Element Name field
14	GPS_CHECK_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Marked as Read flag. Y/N Table Edit Default Value: N