GPIN_SSTD_ADMEE (SQL Table)	Index Back
Store Open period for Employee Record to store the Open period at the Employee level

GPIN_SSTD_ADMEE

(SQL Table)

Store Open period for Employee

Record to store the Open period at the Employee level

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 GPIN_SS_TD_ENABLE Character(1) VARCHAR2(1) NOT NULL Enable Self service.
N=No
Y=Yes
Default Value: N

3 GPIN_TD_OPEN_FROM Character(2) VARCHAR2(2) NOT NULL This is to store the start day of th Open period

4 GPIN_TD_OPEN_TILL Character(2) VARCHAR2(2) NOT NULL This is to store the End date of the Open period.

5 GPIN_TD_FREEZE_DT Date(10) DATE This field is for storing the Freeze date/cut off date at different levels- Employee, Pay group and Pay entity.

6 GPIN_TD_NOTIFY_IND Character(1) VARCHAR2(1) NOT NULL This field is used for storing the selection of rows for being notified about either Open period or Freeze date.
N=N
Y=Y
Default Value: N

7 GPIN_FRZ_NOTIFY_TS Date(10) DATE Used to store the date when an that particular item was notified of it Freeze date on the Administer SS declarations Page.

8 GPIN_OPN_NOTIFY_TS Date(10) DATE Used to store the date when that particular item on the Adminster SS declarations page, was notified of its Open period.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON_PROMPT
2	GPIN_SS_TD_ENABLE	Character(1)	VARCHAR2(1) NOT NULL	Enable Self service. N=No Y=Yes Default Value: N
3	GPIN_TD_OPEN_FROM	Character(2)	VARCHAR2(2) NOT NULL	This is to store the start day of th Open period
4	GPIN_TD_OPEN_TILL	Character(2)	VARCHAR2(2) NOT NULL	This is to store the End date of the Open period.
5	GPIN_TD_FREEZE_DT	Date(10)	DATE	This field is for storing the Freeze date/cut off date at different levels- Employee, Pay group and Pay entity.
6	GPIN_TD_NOTIFY_IND	Character(1)	VARCHAR2(1) NOT NULL	This field is used for storing the selection of rows for being notified about either Open period or Freeze date. N=N Y=Y Default Value: N
7	GPIN_FRZ_NOTIFY_TS	Date(10)	DATE	Used to store the date when an that particular item was notified of it Freeze date on the Administer SS declarations Page.
8	GPIN_OPN_NOTIFY_TS	Date(10)	DATE	Used to store the date when that particular item on the Adminster SS declarations page, was notified of its Open period.