SCRTY_TYPE_CDSCRTY_KEY1GP_ABS_CS_TMPL_IDCWR=Contingent Worker
EMP=Employee
GP_ABS_CFG_SJT(SQL Table) |
Index Back |
|---|---|
CS Security Join TableConfigurable Sections: Template Based Extended Absence Security Join Table - this table contains the denormalized security related attributes from ABS_TEL_TMPL_CFG. This table is used to join Template Based Extended Absence framework. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCRTY_TYPE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Security Type for RowLevelSecurty |
| 2 | SCRTY_KEY1 |
Character(20) | VARCHAR2(20) NOT NULL | Contains the value of the field used for row level security for Job access - setid. |
| 3 | GP_ABS_CS_TMPL_ID |
Character(18) | VARCHAR2(18) NOT NULL | Template ID or Template Section Configuration ID. Used by EA to create templates that are used by Absence requests. |
| 4 | SCRTY_KEY2 | Character(20) | VARCHAR2(20) NOT NULL | Contains the value of the field used for Rowlevelsecurity access to JOB |
| 5 | SCRTY_KEY3 | Character(20) | VARCHAR2(20) NOT NULL | Contains the value of the field used for Rowlevelsecurity access to JOB |
| 6 | CATEGORY_CD | Character(10) | VARCHAR2(10) NOT NULL | Category Code |
| 7 | GP_ABS_CS_PER_ORG | Character(3) | VARCHAR2(3) NOT NULL |
Configurables Sections Setup:
Organizational Relationship
CWR=Contingent Worker EMP=Employee |
| 8 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 9 | EFFDT_NOKEY | Date(10) | DATE | Used in Records /Views where the EFFDT won't be a key |
| 10 | FUTURE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Flag for the SJT_*** record that indicates whether this is a future dated row or not. Y = Future N = Current |