SS_KEYS

(SQL Table)
 Index Back

SS Framework Unique Key Rec

Used in Self Service Framework. Master list of which high level keys (Emplid/Empl_Rcd, for example) can be found in each individual DTL table.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TRANSACTION_NAME Character(25) VARCHAR2(25) NOT NULL EDI Transaction Name
2 SS_GRP_ID Number(15,0) DECIMAL(15) NOT NULL Key Used in SS Framework
3 SS_TRANS_ID Number(15,0) DECIMAL(15) NOT NULL Key Used in SS Framework
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
6 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
7 SUBMITTED_DT Date(10) DATE Used in SS Framework
8 STEPS_REMAINING Number(2,0) SMALLINT NOT NULL Used in SS Framework
9 SAVE_FOR_LATER Number(3,0) SMALLINT NOT NULL Used in SS Framework
10 UPD_BY_USERID Character(30) VARCHAR2(30) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements
11 UPD_DTTM DateTime(26) TIMESTAMP Used on "_DAT" records for 8.3 Workflow Enhancements
12 LAST_PROC_ACTION Character(1) VARCHAR2(1) NOT NULL Used in SS Framework
A=Approve
D=Deny
R=Recycle
S=Submit
13 MANUAL_UPD_USERID Character(30) VARCHAR2(30) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements
14 MANUAL_UPD_DTTM DateTime(26) TIMESTAMP Used on "_DAT" records for 8.3 Workflow Enhancements
15 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

16 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

17 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