HR_MGR_LOC_VW

(SQL View)
 Index Back

WF SS Transaction View

Record used by inquiry page to select data about a particular Locaiton Change transaction

SELECT B.EMPLID , B.EMPL_RCD , B.ACTION_DT_SS , B.EFFSEQ , B.ACTION , B.LOCATION , B.ORIGINATORID , B.TRANSACTION_NAME , B.UPD_BY_USERID , B.UPD_DTTM , B.MANUAL_UPD_USERID , B.MANUAL_UPD_DTTM , B.SS_STAT_INDICATOR , B.SS_WARNING_FLG , B.SS_FUTURE_FLG FROM PS_HR_LOC_TRANS B

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 ACTION_DT_SS Date(10) DATE Termination Date
4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
5 ACTION Character(3) VARCHAR2(3) NOT NULL Action

Prompt Table: ACTION_TBL

6 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
7 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
8 TRANSACTION_NAME Character(25) VARCHAR2(25) NOT NULL EDI Transaction Name
9 UPD_BY_USERID Character(30) VARCHAR2(30) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements
10 UPD_DTTM DateTime(26) TIMESTAMP Used on "_DAT" records for 8.3 Workflow Enhancements
11 MANUAL_UPD_USERID Character(30) VARCHAR2(30) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements
12 MANUAL_UPD_DTTM DateTime(26) TIMESTAMP Used on "_DAT" records for 8.3 Workflow Enhancements
13 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

14 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

15 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