SCC_ADT_ORG_VW

(SQL View)
Index Back

Service Indicator Audit (Org)

Service Indicator Audit View for External Organization

SELECT A.AUDIT_OPRID , A.AUDIT_STAMP , A.SRVC_IND_CD , A.AUDIT_ACTN , A.EXT_ORG_ID , B.DESCR50 , B.EXT_ORG_TYPE , B.ORG_CONTACT , B.ORG_LOCATION , B.ORG_DEPARTMENT , B.PROPRIETORSHIP , B.SETID , B.VENDOR_ID , B.TAXPAYER_ID_NO , 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.OPRID ,A.PROCESS_INSTANCE FROM PS_AUDIT_SRVC_IND A , PS_SCC_SI_ORG_VW B WHERE A.EXT_ORG_ID = B.EXT_ORG_ID

# 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 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
6 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
7 EXT_ORG_TYPE Character(4) VARCHAR2(4) NOT NULL Organization Type

Prompt Table: SCC_ORG_TYP_TBL

8 ORG_CONTACT Number(4,0) SMALLINT NOT NULL Contact Nbr
9 ORG_LOCATION Number(3,0) SMALLINT NOT NULL Location Nbr
10 ORG_DEPARTMENT Number(3,0) SMALLINT NOT NULL Department Nbr
11 PROPRIETORSHIP Character(4) VARCHAR2(4) NOT NULL Proprietorship
OTHR=Other
PRIV=Private
PUBL=Public
RELG=Religious
12 SETID Character(5) VARCHAR2(5) NOT NULL SetID
13 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
14 TAXPAYER_ID_NO Character(9) VARCHAR2(9) NOT NULL Taxpayer ID Number
15 SRVC_IND_DTTM DateTime(26) TIMESTAMP NOT NULL Service Indicator Date-Time field
16 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: OPR_DEF_TBL_CS.INSTITUTION

Prompt Table: INSTITUTION_TBL

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

Prompt Table: SRVC_IN_RSN_TBL

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

Prompt Table: TERM_VAL_TBL

19 SRVC_IND_ACTIVE_DT Date(10) DATE Service Indicator Start Date
20 SCC_SI_END_TERM Character(4) VARCHAR2(4) NOT NULL Service Indicator End Term
21 SCC_SI_END_DT Date(10) DATE Service Indicator End Date
22 POS_SRVC_INDICATOR Character(1) VARCHAR2(1) NOT NULL Positive Service Indicator
23 SRVC_IND_REFRNCE Character(30) VARCHAR2(30) NOT NULL Service Indicator Refrence
24 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
25 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
26 CONTACT Character(30) VARCHAR2(30) NOT NULL Contact Person
27 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
28 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
29 AMOUNT Signed Number(20,3) DECIMAL(18,3) NOT NULL Commuting Allowance Paid Per Cycle.
30 SEQ_3C Number(5,0) INTEGER NOT NULL Sequence Number
31 PLACED_METHOD Character(1) VARCHAR2(1) NOT NULL Method by which Service Indicator is placed.
A=Mass Assign
B=Background
M=Manual
32 PLACED_PERSON Character(30) VARCHAR2(30) NOT NULL Name of person who placed the Service Indicator
33 PLACED_PERSON_ID Character(11) VARCHAR2(11) NOT NULL ID of person who placed the Service Indicator
34 PLACED_PROCESS Character(8) VARCHAR2(8) NOT NULL Process responsible for placing Service Indicator
35 RELEASE_PROCESS Character(8) VARCHAR2(8) NOT NULL Process responsible for releasing the Service Indicator
36 COMM_COMMENTS Long Character(2000) VARCHAR2(2000) Communication Comments
37 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
38 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance