PER_POI_SCRTY (SQL Table)	Index Back
Per Poi Security Contains the data that will be used for this EMPLID/POI_TYPE to provide row level security. This may be by the POI_TYPE, Business Unit(s), Location(s), or Institituion(s). Last_child_upddtm is only updated on a delete in PER_POI_SCRTY.

PER_POI_SCRTY

(SQL Table)

Per Poi Security

Contains the data that will be used for this EMPLID/POI_TYPE to provide row level security. This may be by the POI_TYPE, Business Unit(s), Location(s), or Institituion(s). Last_child_upddtm is only updated on a delete in PER_POI_SCRTY.

Parent record: PER_POI_TYPE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 POI_TYPE Character(5) VARCHAR2(5) NOT NULL Defines the Transactional usage of POIs in HRMS.
Prompt Table: POI_TYPE_TBL

3 EFFDT Date(10) DATE Effective Date
Default Value: %date

4 SCRTY_TYPE_CD Character(3) VARCHAR2(3) NOT NULL Security Type for RowLevelSecurty
Prompt Table: POI_SCRTY_VW

5 SCRTY_KEY2 Character(20) VARCHAR2(20) NOT NULL Contains the value of the field used for Rowlevelsecurity access to JOB
Prompt Table: %EDITTABLE2

6 SCRTY_KEY3 Character(20) VARCHAR2(20) NOT NULL Contains the value of the field used for Rowlevelsecurity access to JOB
Prompt Table: %EDITTABLE3

7 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.
Default Value: %datetime

8 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	POI_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines the Transactional usage of POIs in HRMS. Prompt Table: POI_TYPE_TBL
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	SCRTY_TYPE_CD	Character(3)	VARCHAR2(3) NOT NULL	Security Type for RowLevelSecurty Prompt Table: POI_SCRTY_VW
5	SCRTY_KEY2	Character(20)	VARCHAR2(20) NOT NULL	Contains the value of the field used for Rowlevelsecurity access to JOB Prompt Table: %EDITTABLE2
6	SCRTY_KEY3	Character(20)	VARCHAR2(20) NOT NULL	Contains the value of the field used for Rowlevelsecurity access to JOB Prompt Table: %EDITTABLE3
7	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. Default Value: %datetime
8	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.