| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 HR_MSS_CT_NAME |
Character(25) |
VARCHAR2(25) NOT NULL |
Compound Transaction Name
|
| 2 |
REG_REGION |
Character(5) |
VARCHAR2(5) NOT NULL |
Regulatory Region
Prompt Table:
REG_STANDARD_VW
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
DESCR50 |
Character(50) |
VARCHAR2(50) NOT NULL |
Description of length 50
|
| 5 |
TRANSACTION_NAME |
Character(25) |
VARCHAR2(25) NOT NULL |
EDI Transaction Name
Prompt Table:
HCM_EO_TXN_VW
|
| 6 |
STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Status Indicator
A=Active
I=Inactive
Default Value: A
|
| 7 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|
| 8 |
PTAI_LIST_ID |
Character(31) |
VARCHAR2(31) NOT NULL |
Action Items - Action Item List ID
Prompt Table:
HR_GSS_PTAI_VW
|
| 9 |
EOAWPRCS_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Approval Process ID
|
| 10 |
USE_ATTACHMENTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Attachments
Y/N Table Edit
Default Value: N
|
| 11 |
UPDATE_POSN_DATA |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Position Data
Y/N Table Edit
Default Value: N
|
| 12 |
ACTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Action
Default Value: POS
Prompt Table:
ACTION_TBL_VW
|
| 13 |
ACTION_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Reason Code
Prompt Table:
ACTN_REASON_VW
Set Control Field: ACTION
|
| 14 |
OBJECTOWNERID |
Character(4) |
VARCHAR2(4) NOT NULL |
Object owner identifier
Default Value: HELM
Prompt Table:
HR_SSTEXT_OO_VW
|
| 15 |
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
|
| 16 |
TEXT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Text ID
Prompt Table:
HR_SSTEXT_TX_VW
|
| 17 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
BUSUNIT_HR_VW
|
| 18 |
TBH_TMPL_TXN_TYP |
Character(10) |
VARCHAR2(10) NOT NULL |
Template Transaction Type
Default Value: JOB
Prompt Table:
HR_MNG_TXN_VW1
|
| 19 |
GSS_MULTI_SELECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Multiple Employees
Y/N Table Edit
Default Value: N
|
| 20 |
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.
Y/N Table Edit
Default Value: N
|
| 21 |
HR_GSS_MULT_TRN |
Character(1) |
VARCHAR2(1) NOT NULL |
Gender Identity Flag
Y/N Table Edit
Default Value: N
|