| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
TRANSACTION_NAME |
Character(25) |
VARCHAR2(25) NOT NULL |
EDI Transaction Name
|
| 3 |
SS_GRP_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Key Used in SS Framework
|
| 4 |
SS_TRANS_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Key Used in SS Framework
|
| 5 |
SS_PROCESS_CYCLE |
Number(3,0) |
SMALLINT NOT NULL |
Used in SS Framework
|
| 6 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 7 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 8 |
COURSE |
Character(6) |
VARCHAR2(6) NOT NULL |
Course Code
|
| 9 |
SESSION_NBR |
Character(4) |
VARCHAR2(4) NOT NULL |
Course Session Nbr
|
| 10 |
ACTION_DT_SS |
Date(10) |
DATE |
Termination Date
|
| 11 |
MANAGER |
Character(1) |
VARCHAR2(1) NOT NULL |
manager
|
| 12 |
NEW_COMP_RATE_PTS |
Number(5,0) |
INTEGER NOT NULL |
New Comp Rate Points
|
| 13 |
CHANGE_PCT |
Signed Number(8,3) |
DECIMAL(6,3) NOT NULL |
Change Percent
|
| 14 |
HR_WF_ACTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Workflow Action
APV=Approved
CAN=Cancelled by Originator
DNY=Denied
PND=Pending
PSH=Push back for rework
RAS=Reassign
SAV=Saved For Later-Not Submitted
SUB=Submitted
|
| 15 |
HR_WF_STATUS |
Character(30) |
VARCHAR2(30) NOT NULL |
Status
|
| 16 |
COMMENTS |
Long Character |
CLOB |
Comment
|
| 17 |
CURRENT_STEP |
Number(3,0) |
SMALLINT NOT NULL |
Current Step Number
|
| 18 |
TRANS_DT |
Date(10) |
DATE |
Transaction Date
|
| 19 |
COUNTER |
Number(10,0) |
DECIMAL(10) NOT NULL |
Counter
|
| 20 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
| 21 |
COMP_EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Compensation Eff Sequence
|
| 22 |
COMP_RATECD |
Character(6) |
VARCHAR2(6) NOT NULL |
Comp Rate Code
|
| 23 |
COMP_RATE_POINTS |
Number(5,0) |
INTEGER NOT NULL |
Comp Rate Points
|
| 24 |
COMPRATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Compensation Rate
|
| 25 |
NEW_COMPRATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
New Compensation Rate
|
| 26 |
COMP_PCT |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
Comp Percent
|
| 27 |
NEW_COMP_PCT |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
New Comp Percent
|
| 28 |
COMP_FREQUENCY |
Character(5) |
VARCHAR2(5) NOT NULL |
Compensation Frequency
A=Annual
B=Biweekly
C=Contract
D=Daily
H=Hourly
M=Monthly
S=Semimonthly
W=Weekly
|
| 29 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 30 |
MANUAL_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Manual Switch
|
| 31 |
CONVERT_COMPRT |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Converted Comp Rate
|
| 32 |
RATE_CODE_GROUP |
Character(6) |
VARCHAR2(6) NOT NULL |
Rate Code Group Name
|
| 33 |
CHANGE_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Change Amount
|
| 34 |
CHANGE_PTS |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
Change Points
|
| 35 |
FTE_INDICATOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply FTE for Annualization
|
| 36 |
CMP_SRC_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Rate Code Source Indicator
A=Absorbing Premium
B=Non-Absorbing Premium
C=Combination Rule
E=Seniority Pay
J=Job Code
M=Manual
N=None
P=Payroll
R=Employee Review
S=Salary Step
|
| 37 |
PROCESS_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Used in SS Framework
A=Approve
D=Deny
R=Recycle
S=Submit
|
| 38 |
GB_GROUP_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Group Build ID.
|
| 39 |
APPR_STEP |
Character(3) |
VARCHAR2(3) NOT NULL |
Approval Step
1=Approval Step 1
2=Approval Step 2
3=Approval Step 3
4=Approval Step 4
5=Approval Step 5
6=Approval Step 6
7=Approval Step 7
8=Approval Step 8
9=Approval Step 9
|
| 40 |
APPR_PATH |
Character(3) |
VARCHAR2(3) NOT NULL |
Approval Path
A=Approval Path A
B=Approval Path B
C=Approval Path C
D=Approval Path D
E=Approval Path E
|
| 41 |
ROLEUSER |
Character(30) |
VARCHAR2(30) NOT NULL |
Role User
|
| 42 |
ROLENAME |
Character(30) |
VARCHAR2(30) NOT NULL |
The name of a Role in the Role Definition Table (see PSROLEDEFN).
|
| 43 |
EMPLID_TO |
Character(11) |
VARCHAR2(11) NOT NULL |
EmplID To
|
| 44 |
SEQNO |
Number(5,0) |
INTEGER NOT NULL |
Sequence Number
|
| 45 |
ORIGINATOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Originator
E=Employee
S=Supervisor
|
| 46 |
PROCESS_STEP |
Number(3,0) |
SMALLINT NOT NULL |
Used in SS Framework
|
| 47 |
ORIGINATORID |
Character(30) |
VARCHAR2(30) NOT NULL |
Originator Identifier
|
| 48 |
SUBMITTED_DT |
Date(10) |
DATE |
Used in SS Framework
|
| 49 |
STEPS_REMAINING |
Number(2,0) |
SMALLINT NOT NULL |
Used in SS Framework
|
| 50 |
SAVE_FOR_LATER |
Number(3,0) |
SMALLINT NOT NULL |
Used in SS Framework
|
| 51 |
UPD_BY_USERID |
Character(30) |
VARCHAR2(30) NOT NULL |
Used on "_DAT" records for 8.3 Workflow Enhancements
|
| 52 |
UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Used on "_DAT" records for 8.3 Workflow Enhancements
|
| 53 |
LAST_PROC_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Used in SS Framework
A=Approve
D=Deny
R=Recycle
S=Submit
|
| 54 |
MANUAL_UPD_USERID |
Character(30) |
VARCHAR2(30) NOT NULL |
Used on "_DAT" records for 8.3 Workflow Enhancements
|
| 55 |
MANUAL_UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Used on "_DAT" records for 8.3 Workflow Enhancements
|
| 56 |
SS_STAT_INDICATOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Used on "_DAT" records for 8.3 Workflow Enhancements
A=Approved
B=CI failed - Errors & Warnings
C=Cancelled
D=Denied
E=Errors Encountered
I=In Approval Process
M=Administrator Action Required
S=Success
W=Warnings Encountered
Default Value: I
|
| 57 |
SS_WARNING_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Used on "_DAT" records for 8.3 Workflow Enhancements
Y/N Table Edit
Default Value: N
|
| 58 |
SS_FUTURE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Used on "_DAT" records for 8.3 Workflow Enhancements
Y/N Table Edit
Default Value: N
|