| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 HR_MSS_CT_NAME |
Character(25) |
VARCHAR2(25) NOT NULL |
Compound Transaction Name
Default Value: HR_MSS_CT_CFG.HR_MSS_CT_NAME
|
| 2 |
REG_REGION |
Character(5) |
VARCHAR2(5) NOT NULL |
Regulatory Region
Default Value: HR_MSS_CT_CFG.REG_REGION
Prompt Table:
REG_STANDARD_VW
|
| 3 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: HR_MSS_CT_CFG.EFFDT
|
| 4 |
SEQUENCE |
Number(2,0) |
SMALLINT NOT NULL |
Chartfield Sequence
|
| 5 |
OBJECTOWNERID |
Character(4) |
VARCHAR2(4) NOT NULL |
Object owner identifier
Default Value: HELM
Prompt Table:
HR_SSTEXT_OO_VW
|
| 6 |
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.
Default Value: CT
Prompt Table:
HR_SSTEXT_OS_VW
|
| 7 |
TEXT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Text ID
Prompt Table:
HR_SSTEXT_TX_VW
|
| 8 |
TEXT_ID2 |
Character(18) |
VARCHAR2(18) NOT NULL |
Small Form Factor Text ID
Prompt Table:
HR_SSTEXT_TX_VW
|
| 9 |
ACTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Action
Prompt Table:
ACTION_TBL_VW
|
| 10 |
ACTION_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Reason Code
Prompt Table:
ACTN_REASON_VW
Set Control Field: ACTION
|
| 11 |
HIDE_REASON_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Hide Action Reason flag
Y/N Table Edit
Default Value: N
|
| 12 |
PNLNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Page Name (see PSPNLDEFN).
Prompt Table:
PSPNLDEFN_VW
|
| 13 |
DEFAULT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Set As Default
N=No
Y=Yes
Default Value: N
|
| 14 |
HIDDEN_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Hidden Flag
Y/N Table Edit
Default Value: N
|
| 15 |
REASON_REQ_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Action Reason Required flag
Y/N Table Edit
Default Value: Y
|
| 16 |
SYSTEM_DATA_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.
Default Value: N
|