AUDIT_SI_VW

(SQL View)
Index Back

Audit Ind/People Data View


SELECT A.AUDIT_OPRID , A.AUDIT_STAMP , A.SRVC_IND_CD , A.AUDIT_ACTN , A.EMPLID , A.EXT_ORG_ID , A.SRVC_IND_DTTM , A.INSTITUTION , A.SRVC_IND_REASON , A.SRVC_IND_ACT_TERM , A.SRVC_IND_ACTIVE_DT , A.SCC_SI_END_TERM , A.SCC_SI_END_DT , A.POS_SRVC_INDICATOR , A.SRVC_IND_REFRNCE , A.DEPTID , A.POSITION_NBR , A.CONTACT , A.CONTACT_ID , A.CURRENCY_CD , A. AMOUNT , A.SEQ_3C , A.PLACED_METHOD , A.PLACED_PERSON , A.PLACED_PERSON_ID ,A.PLACED_PROCESS ,A.RELEASE_PROCESS ,A.COMM_COMMENTS ,A.RELEASE_PROCESS ,A.PROCESS_INSTANCE FROM PS_AUDIT_SRVC_IND A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 AUDIT_OPRID Character(30) VARCHAR2(30) NOT NULL The OPRID of the user who made the changes audited on an audit record.
2 AUDIT_STAMP DateTime(26) TIMESTAMP Date and Time Stamp
3 SRVC_IND_CD Character(3) VARCHAR2(3) NOT NULL Service Indicator Cd

Prompt Table: SRVC_IND_CD_TBL

4 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values
5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PEOPLE_SRCH

6 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
7 SRVC_IND_DTTM DateTime(26) TIMESTAMP NOT NULL Service Indicator Date-Time field
8 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: OPR_DEF_TBL_CS.INSTITUTION

Prompt Table: INSTITUTION_TBL

9 SRVC_IND_REASON Character(5) VARCHAR2(5) NOT NULL Service Indicator Reason

Prompt Table: SRVC_IN_RSN_TBL

10 SRVC_IND_ACT_TERM Character(4) VARCHAR2(4) NOT NULL Service Indicator Start Term

Prompt Table: TERM_VAL_TBL

11 SRVC_IND_ACTIVE_DT Date(10) DATE Service Indicator Start Date
12 SCC_SI_END_TERM Character(4) VARCHAR2(4) NOT NULL Service Indicator End Term
13 SCC_SI_END_DT Date(10) DATE Service Indicator End Date
14 POS_SRVC_INDICATOR Character(1) VARCHAR2(1) NOT NULL Positive Service Indicator
15 SRVC_IND_REFRNCE Character(30) VARCHAR2(30) NOT NULL Service Indicator Refrence
16 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
17 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
18 CONTACT Character(30) VARCHAR2(30) NOT NULL Contact Person
19 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
20 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
21 AMOUNT Signed Number(20,3) DECIMAL(18,3) NOT NULL Commuting Allowance Paid Per Cycle.
22 SEQ_3C Number(5,0) INTEGER NOT NULL Sequence Number
23 PLACED_METHOD Character(1) VARCHAR2(1) NOT NULL Method by which Service Indicator is placed.
A=Mass Assign
B=Background
M=Manual
24 PLACED_PERSON Character(30) VARCHAR2(30) NOT NULL Name of person who placed the Service Indicator
25 PLACED_PERSON_ID Character(11) VARCHAR2(11) NOT NULL ID of person who placed the Service Indicator
26 PLACED_PROCESS Character(8) VARCHAR2(8) NOT NULL Process responsible for placing Service Indicator
27 RELEASE_PROCESS Character(8) VARCHAR2(8) NOT NULL Process responsible for releasing the Service Indicator
28 COMM_COMMENTS Long Character(2000) VARCHAR2(2000) Communication Comments
29 SCC_AUDIT_RELSPRCS Character(4) VARCHAR2(4) NOT NULL New field for Audit Service Indicator - Release Process translate values.
RELS=Mass Release
TASK=Task Completion
30 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance