EE_EVENT_ALL_VW

(SQL View)
 Index Back

All Entry Events

All effective entry event codes as of the current date.

SELECT A.SETID , A.ENTRY_EVENT , A.EE_PROCESS , A.EFFDT , A.EFF_STATUS , B.EE_EVENT_STEP , D.REVERSAL_FLG , B.APPL_JRNL_ID , C.EVENT_LINE , C.DEBIT_CREDIT , C.ACCOUNT , C.ALTACCT FROM PS_EE_EVENT_PRCS A , PS_EE_EVENT_STEP B , PS_EE_EVENT_ACCT C , PS_EE_PRCS_STEP D WHERE A.SETID = B.SETID AND A.ENTRY_EVENT = B.ENTRY_EVENT AND A.EE_PROCESS = B.EE_PROCESS AND A.EFFDT = B.EFFDT AND D.EE_PROCESS = B.EE_PROCESS AND D.EE_EVENT_STEP = B.EE_EVENT_STEP AND A.SETID = C.SETID AND A.ENTRY_EVENT = C.ENTRY_EVENT AND A.EE_PROCESS = C.EE_PROCESS AND A.EFFDT = C.EFFDT AND B.EE_EVENT_STEP = C.EE_EVENT_STEP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 ENTRY_EVENT Character(10) VARCHAR2(10) NOT NULL Entry Event
3 EE_PROCESS Character(10) VARCHAR2(10) NOT NULL Entry Event Process

Prompt Table: EE_PRCS_HDR

4 EFFDT Date(10) DATE NOT NULL Effective Date
5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
6 EE_EVENT_STEP Character(10) VARCHAR2(10) NOT NULL Entry Event Step
7 REVERSAL_FLG Character(1) VARCHAR2(1) NOT NULL Reversal Flag
N=Do Not Create Reversals
Y=Create Reversals
8 APPL_JRNL_ID Character(10) VARCHAR2(10) NOT NULL Journal Template
9 EVENT_LINE Number(5,0) INTEGER NOT NULL Entry Event Line Number
10 DEBIT_CREDIT Character(2) VARCHAR2(2) NOT NULL Debit / Credit Indicator
CR=Credit
DR=Debit
11 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
12 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account