TRANSACTION_NAMESS_GRP_IDSS_TRANS_IDSS_PROCESS_CYCLEPROCESS_PATHPROCESS_STEPROLEUSERSS_ROLETYPEADM=Administrator
APR=Approver
INP=Interested Party
ORG=Originator
A=Approve
D=Deny
R=Recycle
S=Submit
SS_PROC_CMNTS(SQL Table) |
Index Back |
|---|---|
SS Framework Process DetailUsed in Self Service Framework. Temporary Record that presents all comments entered by process participants. |
| # | 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 | SS_PROCESS_CYCLE |
Number(3,0) | SMALLINT NOT NULL | Used in SS Framework |
| 5 | PROCESS_PATH |
Character(3) | VARCHAR2(3) NOT NULL | Used in SS Framework |
| 6 | PROCESS_STEP |
Number(3,0) | SMALLINT NOT NULL | Used in SS Framework |
| 7 | ROLEUSER |
Character(30) | VARCHAR2(30) NOT NULL | Role User |
| 8 | IS_ALTERNATE | Number(1,0) | SMALLINT NOT NULL | Is Alternate Flag |
| 9 | SS_ROLETYPE |
Character(3) | VARCHAR2(3) NOT NULL |
Used in SS Framework
ADM=Administrator APR=Approver INP=Interested Party ORG=Originator |
| 10 | ROLENAME | Character(30) | VARCHAR2(30) NOT NULL | The name of a Role in the Role Definition Table (see PSROLEDEFN). |
| 11 | ROLEUSER_EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Used in SS Framework |
| 12 | PROCESS_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Used in SS Framework
A=Approve D=Deny R=Recycle S=Submit |
| 13 | PROCESS_ACTION_DT | Date(10) | DATE | Process Action Date |
| 14 | CURRENT_STEP | Number(3,0) | SMALLINT NOT NULL | Current Step Number |
| 15 | SAVE_FOR_LATER | Number(3,0) | SMALLINT NOT NULL | Used in SS Framework |
| 16 | COMMENTS | Long Character | CLOB | Comment |