| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
GP_COUNTRY
|
| 2 |
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.
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
GP_ABS_SEC_COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Section Country
Prompt Table:
GP_ABS_CS_CNTRY
|
| 5 |
GP_ABS_CS_SEC_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Template Section ID
Prompt Table:
GP_ABS_SECDEFVW
|
| 6 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
Default Value: 1
|
| 7 |
GP_ABS_CS_LBL_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Configurable Sections Setup:
Template Section Label Field
D=Use Section Description
M=Use Message Catalog
S=Use Static Text
T=Use Text Catalog
Default Value: D
|
| 8 |
HR_SSTEXT_SUB_ID |
Character(4) |
VARCHAR2(4) NOT NULL |
The Sub ID is field that is optionally used to further partition Text Catalog entries within an Object Owner ID.
For example, we might want to create a Sub ID to keep Text Catalog entries for Enrollment separate from the Text Catalog entries for the inquiry pages within the eBenefits ObjectOwnerId.
Prompt Table:
GP_ABS_SUBID_VW
|
| 9 |
TEXT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Text ID
Prompt Table:
GP_ABS_TXID_VW
|
| 10 |
MESSAGE_SET_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
Prompt Table:
PSMSGSETDEFN
|
| 11 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
Prompt Table:
PSMSGCATDEFN
|
| 12 |
GP_ABS_SEC_LBL_TXT |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 13 |
ENABLED |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag indicates whether this row is enabled or not.
Y/N Table Edit
Default Value: Y
|
| 14 |
HIDDEN_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Hidden Flag
Y/N Table Edit
Default Value: N
|
| 15 |
ROLENAME |
Character(30) |
VARCHAR2(30) NOT NULL |
The name of a Role in the Role Definition Table (see PSROLEDEFN).
Prompt Table:
PSROLEDEFN
|
| 16 |
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
|
| 17 |
PAGE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Page Nbr
Default Value: 1
|