AUDIT_IND_SRCH

(SQL View)
 Index Back

Audit Ind/People Data View

STDNT_AID_SRCH is the main financial aid application search record. It provides the user with a list box of only students that are on the Student Aid table for the year selected. The list box will also provide identifying information from the Personal_Data table.

SELECT B.OPRCLASS ,A.AUDIT_OPRID , A.AUDIT_STAMP , A.EMPLID , A.SRVC_IND_CD , A.AUDIT_ACTN , 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 , B.BIRTHDATE , B.BIRTHDATE_MSK , E.NAME , C.COUNTRY , C.NATIONAL_ID_TYPE , D.DESCRSHORT , C.NATIONAL_ID , C.NATIONAL_ID_MSK , B.CAMPUS_ID , F.SEX , E.LAST_NAME_SRCH , E.FIRST_NAME_SRCH , A.PLACED_PERSON_ID , A.DEPTID , A.PLACED_PROCESS , A.PLACED_METHOD , A.RELEASE_PROCESS , A.OPRID , A.PROCESS_INSTANCE FROM PS_AUDIT_SRVC_IND A , PS_PERSON_MSK_VW B , PS_PERS_NID_MSK_VW C , PS_HCR_NID_TYP_I D , PS_HCR_PERSON_NM_I E , PS_HCR_PER_PDE_I F WHERE B.OPRCLASS = C.OPRCLASS AND A.EMPLID = B.EMPLID AND A.EMPLID = C.EMPLID AND A.EMPLID = E.EMPLID AND A.EMPLID = F.EMPLID AND D.COUNTRY = C.COUNTRY AND D.NATIONAL_ID_TYPE = C.NATIONAL_ID_TYPE AND F.EFFDT = ( SELECT MAX(F1.EFFDT) FROM PS_HCR_PER_PDE_I F1 WHERE F.EMPLID = F1.EMPLID AND F1.EFFDT <=%CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
2 AUDIT_OPRID Character(30) VARCHAR2(30) NOT NULL The OPRID of the user who made the changes audited on an audit record.
3 AUDIT_STAMP DateTime(26) TIMESTAMP Date and Time Stamp
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PEOPLE_SRCH

5 SRVC_IND_CD Character(3) VARCHAR2(3) NOT NULL Service Indicator Cd

Prompt Table: SRVC_IND_CD_TBL

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

Default Value: OPR_DEF_TBL_CS.INSTITUTION

Prompt Table: INSTITUTION_TBL

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

Prompt Table: SRVC_IN_RSN_TBL

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

Prompt Table: TERM_VAL_TBL

12 SRVC_IND_ACTIVE_DT Date(10) DATE Service Indicator Start Date
13 SCC_SI_END_TERM Character(4) VARCHAR2(4) NOT NULL Service Indicator End Term
14 SCC_SI_END_DT Date(10) DATE Service Indicator End Date
15 BIRTHDATE Date(10) DATE Date of Birth
16 BIRTHDATE_MSK Character(10) VARCHAR2(10) NOT NULL Date of Birth
17 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
18 NID_COUNTRY Character(3) VARCHAR2(3) NOT NULL National ID Country
19 NATIONAL_ID_TYPE Character(6) VARCHAR2(6) NOT NULL National ID Type
20 NID_DESCRSHORT Character(10) VARCHAR2(10) NOT NULL NID Short Description
21 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
22 NATIONAL_ID_MSK Character(20) VARCHAR2(20) NOT NULL National ID
23 CAMPUS_ID Character(16) VARCHAR2(16) NOT NULL Campus ID
24 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
25 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
26 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
27 PLACED_PERSON_ID Character(11) VARCHAR2(11) NOT NULL ID of person who placed the Service Indicator
28 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPT_TBL_ACCESS
Set Control Field: INSTITUTION

29 PLACED_PROCESS Character(8) VARCHAR2(8) NOT NULL Process responsible for placing Service Indicator
30 PLACED_METHOD Character(1) VARCHAR2(1) NOT NULL Method by which Service Indicator is placed.
A=Mass Assign
B=Background
M=Manual
31 RELEASE_PROCESS Character(8) VARCHAR2(8) NOT NULL Process responsible for releasing the Service Indicator
32 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
33 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance