COUNTRYPrompt Table: GP_CNTRY_OP_VW
PIN_TAKE_NUMPrompt Table: GP_ABS_SS_ADD
EFFDTDefault Value: %date
PNLGRPNAMEPrompt Table: PSPNLGRPDEFN_VW
Prompt Table: GP_ABS_TMPL_HDR
D=Display Only
F=Full Edit
GP_ABS_CFNRP_VW(SQL View) |
Index Back |
|---|---|
Country Take Config Sct NRP VWCountry Take Config Section NRP View |
| SELECT COUNTRY , PIN_TAKE_NUM , EFFDT , PNLGRPNAME , GP_ABS_CS_TMPL_ID , GP_ABS_CS_AUTH FROM PS_GP_ABS_SS_CONFG |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: GP_CNTRY_OP_VW |
| 2 | PIN_TAKE_NUM |
Number(8,0) | INTEGER NOT NULL |
Absence Take
Prompt Table: GP_ABS_SS_ADD |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | PNLGRPNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Component Name
Prompt Table: PSPNLGRPDEFN_VW |
| 5 | 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.
Prompt Table: GP_ABS_TMPL_HDR |
| 6 | GP_ABS_CS_AUTH | Character(1) | VARCHAR2(1) NOT NULL |
Configurable Sections Setup:
At setup level user will be able to create/maintain the view/edit accesses to determine if a role can view and/or edit specific sections/templates.
D=Display Only F=Full Edit |