POI_TYPE_TBL_VW(SQL View) |
Index Back |
|---|---|
POI Type TableTypes of Persons of Interest. |
| SELECT POI_TYPE ,DESCR ,DESCRSHORT ,EFF_STATUS ,OBJECTOWNERID ,RECNAME_POI_TRANS ,RECNAME_POI_VW ,PNLGRPNAME ,MARKET ,MENUNAME ,ITEMNAME ,BARNAME ,PNLNAME ,JOB_REQUIRED ,DFLT_CHKLST_POI ,USE_IN_POI_ADD ,USE_IN_POI_UPD ,USE_IN_DI ,COMMENTS FROM PS_POI_TYPE_TBL WHERE EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  POI_TYPE |
Character(5) | VARCHAR2(5) NOT NULL | Defines the Transactional usage of POIs in HRMS. |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | OBJECTOWNERID | Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier |
| 6 | RECNAME_POI_TRANS | Character(15) | VARCHAR2(15) NOT NULL |
Record for POI Transaction
Prompt Table: PSRECDEFN |
| 7 | RECNAME_POI_VW | Character(15) | VARCHAR2(15) NOT NULL |
Record for POI Summary View
Prompt Table: PSRECDEFN |
| 8 | PNLGRPNAME | Character(18) | VARCHAR2(18) NOT NULL |
Component Name
Prompt Table: PSPNLGRPDEFN_VW |
| 9 | MARKET | Character(3) | VARCHAR2(3) NOT NULL |
Market
Prompt Table: PSPNLGRP_SRCH |
| 10 | MENUNAME | Character(30) | VARCHAR2(30) NOT NULL | Menu Name (see PSMENUDEFN). |
| 11 | ITEMNAME | Character(30) | VARCHAR2(30) NOT NULL | Item Name |
| 12 | BARNAME | Character(30) | VARCHAR2(30) NOT NULL | Menu Bar Name |
| 13 | PNLNAME | Character(30) | VARCHAR2(30) NOT NULL | Page Name (see PSPNLDEFN). |
| 14 | JOB_REQUIRED | Character(1) | VARCHAR2(1) NOT NULL |
Y/N field to indicated whether a JOB record is required for a particular POI_TYPE
Y/N Table Edit Default Value: N |
| 15 | DFLT_CHKLST_POI | Character(6) | VARCHAR2(6) NOT NULL |
Installation field to hold the default checklist code for a Person of Interest
Prompt Table: CHECKLIST_TBL |
| 16 | USE_IN_POI_ADD | Character(1) | VARCHAR2(1) NOT NULL |
Flag to indicate if a POI_TYPE should be allowed to be added using the generic Add Component - PER_POI_ADD.
Y/N Table Edit Default Value: Y |
| 17 | USE_IN_POI_UPD | Character(1) | VARCHAR2(1) NOT NULL |
Flag to indicate if a POI_TYPE should be allowed to be updated using the generic UpdateComponent - PERS_POI_MAINTAIN
Y/N Table Edit Default Value: Y |
| 18 | USE_IN_DI | Character(1) | VARCHAR2(1) NOT NULL |
Y/N flag to indicate that a person with a specific POI_TYPE should be sent to the Directory via the Directory Interace.
Employees and Contingent Workers (if active) are always sent - but not all POI_TYPEs should be.
This is not implemented yet, so the field will be hidden and will default to 'N'
Y/N Table Edit Default Value: N |
| 19 | COMMENTS | Long Character | CLOB | Comment |