SS_KEYS_APPR

(SQL Table)
 Index Back

SS Framework Approve Tmp Rec

Used in Self Service Framework. Temporary Record that presents all request that were approved, and cannot be edited by the current user.

# 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