TRGR_3CS_VW

(SQL View)
 Index Back

Trigger Table


SELECT A.INSTITUTION , A.EVENT_3CS_ID , A.SA_ID_TYPE , A.COMMON_ID , A.SEQNO , A.DATE_ADDED , A.ADMIN_FUNCTION , %subrec(COMM_VAR_DATA, A) , A.SCC_TRGR_STATUS , A.TRGR_SOURCE , A.OPRID , A.COMM_ID , A.COMMENT_PRINT_FLAG , A.COMM_COMMENTS FROM PS_TRGR_3CS_TBL A WHERE SEQNO = ( SELECT MAX(SEQNO) FROM PS_TRGR_3CS_TBL B , PS_ADM_FUNCTN_TBL C WHERE A.INSTITUTION = B.INSTITUTION AND A.EVENT_3CS_ID = B.EVENT_3CS_ID AND A.SA_ID_TYPE = B.SA_ID_TYPE AND A.COMMON_ID = B.COMMON_ID AND A.ADMIN_FUNCTION = B.ADMIN_FUNCTION AND A.SCC_TRGR_STATUS = B.SCC_TRGR_STATUS AND A.COMMENT_PRINT_FLAG = B.COMMENT_PRINT_FLAG AND A.ACAD_CAREER = B.ACAD_CAREER AND A.STDNT_CAR_NBR = B.STDNT_CAR_NBR AND A.ACAD_PROG = B.ACAD_PROG AND A.ACAD_PLAN = B.ACAD_PLAN AND A.STRM = B.STRM AND A.CLASS_NBR = B.CLASS_NBR AND A.AID_YEAR = B.AID_YEAR AND A.CAMPUS_EVENT_NBR = B.CAMPUS_EVENT_NBR AND A.EVENT_MTG_NBR = B.EVENT_MTG_NBR AND A.ADM_APPL_NBR = B.ADM_APPL_NBR AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.CASHIER_OFFICE = B.CASHIER_OFFICE AND A.COLLECTION_ID = B.COLLECTION_ID AND A.CONTRACT_NUM = B.CONTRACT_NUM AND A.GROUP_ID_SF = B.GROUP_ID_SF AND A.INVOICE_ID = B.INVOICE_ID AND A.ITEM_NBR = B.ITEM_NBR AND A.LINE_SEQ_NBR = B.LINE_SEQ_NBR AND A.PAYMENT_ID_NBR = B.PAYMENT_ID_NBR AND A.RECEIPT_NBR = B.RECEIPT_NBR AND A.REFUND_NBR = B.REFUND_NBR AND A.APPL_PROG_NBR = B.APPL_PROG_NBR AND A.EFFSEQ_VAR = B.EFFSEQ_VAR AND A.ITEM_TYPE = B.ITEM_TYPE AND A.ACCOUNT_NBR = B.ACCOUNT_NBR AND A.ACCOUNT_TERM = B.ACCOUNT_TERM AND A.LOAN_TYPE = B.LOAN_TYPE AND A.LN_APPL_SEQ = B.LN_APPL_SEQ AND A.RESTRICTED_AID_ID = B.RESTRICTED_AID_ID AND A.SESSION_NO = B.SESSION_NO AND A.GIFT_NO = B.GIFT_NO AND A.RECOGNITION_TYPE = B.RECOGNITION_TYPE AND A.DESIGNATION = B.DESIGNATION AND A.INTV_CD = B.INTV_CD AND A.AV_AUDIENCE = B.AV_AUDIENCE AND A.AUD_TYPE = B.AUD_TYPE AND A.MEMBERSHIP_NBR = B.MEMBERSHIP_NBR AND A.AV_MBR_ORG_COD = B.AV_MBR_ORG_COD AND A.AV_STD_BEN = B.AV_STD_BEN AND A.MBR_PMT_NO = B.MBR_PMT_NO AND A.LN_APPL_ID = B.LN_APPL_ID AND A.SAD_PB_CAS_NUMBER = B.SAD_PB_CAS_NUMBER AND A.SSR_RS_CANDIT_ID = B.SSR_RS_CANDIT_ID AND A.SSR_RS_CANDIT_NBR = B.SSR_RS_CANDIT_NBR AND A.SSR_RS_SUBMSSN_NBR = B.SSR_RS_SUBMSSN_NBR AND A.SSR_RS_TOPIC_SEQ = B.SSR_RS_TOPIC_SEQ AND A.SSR_RS_SUPER_NBR = B.SSR_RS_SUPER_NBR AND A.SSR_RS_RQUIRE_TYPE = B.SSR_RS_RQUIRE_TYPE AND (C.EFFDT_AF = 'N' OR A.EFFDT_VAR = B.EFFDT_VAR) AND (C.CHECKLIST_DTTM_AF = 'N' OR A.CHECKLIST_DTTM_VAR = B.CHECKLIST_DTTM_VAR))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: OPR_DEF_TBL_CS.INSTITUTION

Prompt Table: INSTITUTION_TBL

2 EVENT_3CS_ID Character(10) VARCHAR2(10) NOT NULL 3Cs event ID

Prompt Table: EVNT_3CS_VW

3 SA_ID_TYPE Character(1) VARCHAR2(1) NOT NULL ID Type
O=Organization
P=Person

Default Value: P

4 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value

Prompt Table: %EDITTABLE19

5 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
6 DATE_ADDED Date(10) DATE NOT NULL Date Added

Default Value: %date

7 ADMIN_FUNCTION Character(4) VARCHAR2(4) NOT NULL Administrative Function

Default Value: EVNT_3CS_TBL.ADMIN_FUNCTION

Prompt Table: %EDITTABLE20

8 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
BAC=Bachelor (NLD)
BBL=Vocational Coaching (NLD)
BOL=Vocational Training (NLD)
BUSN=Graduate Business
CNED=Continuing Education
CRED=Semester Credit
EDU=Education (NLD)
EXED=Extended Education
GRAD=Graduate
LAW=Law
MEDS=Medical School
NONA=Non Award
PGRD=Postgraduate
RSCH=Research
TECH=Technical
UENG=Undergraduate Engineering
UGRD=Undergraduate
VAVO=Advanced General Educ. (NLD)
VETM=Veterinary Medicine

Prompt Table: %EDITTABLE14

9 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr

Prompt Table: %EDITTABLE11

10 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program

Prompt Table: ACAD_PROG_TBL

11 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan

Prompt Table: ACAD_PLAN

12 STRM Character(4) VARCHAR2(4) NOT NULL Term

Prompt Table: %EDITTABLE10

13 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

Prompt Table: STUDENT_AID

14 CAMPUS_EVENT_NBR Character(9) VARCHAR2(9) NOT NULL Event ID

Prompt Table: CAMPUS_EVENT_VW

15 EVENT_MTG_NBR Number(4,0) SMALLINT NOT NULL Event Meeting Nbr

Prompt Table: EVENT_MTG

16 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application Nbr

Prompt Table: APPL_NBR_DVW

17 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: BUS_UNIT_TBL_SF

18 CASHIER_OFFICE Character(8) VARCHAR2(8) NOT NULL Cashier's Office

Prompt Table: CSH_OFF_TBL

19 COLLECTION_ID Number(12,0) DECIMAL(12) NOT NULL Collection ID

Prompt Table: %EDITTABLE9

20 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number

Prompt Table: TP_CONTRACT

21 GROUP_ID_SF Character(15) VARCHAR2(15) NOT NULL Group ID

Prompt Table: GROUP_CONT_INFO

22 INVOICE_ID Character(22) VARCHAR2(22) NOT NULL Invoice Number

Prompt Table: %EDITTABLE3

23 ITEM_NBR Character(15) VARCHAR2(15) NOT NULL Item Nbr

Prompt Table: %EDITTABLE7

24 LINE_SEQ_NBR Number(3,0) SMALLINT NOT NULL Line Sequence Nbr

Prompt Table: %EDITTABLE8

25 PAYMENT_ID_NBR Number(12,0) DECIMAL(12) NOT NULL Payment ID Nbr

Prompt Table: %EDITTABLE4

26 RECEIPT_NBR Number(12,0) DECIMAL(12) NOT NULL Receipt Number

Prompt Table: %EDITTABLE5

27 REFUND_NBR Number(12,0) DECIMAL(12) NOT NULL Refund Nbr

Prompt Table: %EDITTABLE6

28 APPL_PROG_NBR Number(3,0) SMALLINT NOT NULL Application Program Nbr

Prompt Table: ADM_APPL_PROG

29 EFFDT_VAR Date(10) DATE Effective Date
30 EFFSEQ_VAR Number(1,0) SMALLINT NOT NULL Effective Date Sequence #
31 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type

Prompt Table: %EDITTABLE13

32 ACCOUNT_NBR Character(10) VARCHAR2(10) NOT NULL Account Nbr

Prompt Table: %EDITTABLE

33 ACCOUNT_TERM Character(4) VARCHAR2(4) NOT NULL Account Term

Prompt Table: %EDITTABLE2

34 CHECKLIST_DTTM_VAR DateTime(26) TIMESTAMP Checklist Date Time
35 LOAN_TYPE Character(4) VARCHAR2(4) NOT NULL Loan Type Cd

Prompt Table: LN_TYPE_TBL

36 LN_APPL_SEQ Number(2,0) SMALLINT NOT NULL Loan Application Seq Num
37 RESTRICTED_AID_ID Character(10) VARCHAR2(10) NOT NULL Restricted Aid ID

Prompt Table: STDNT_RSTRC_AID

38 SESSION_NO Character(11) VARCHAR2(11) NOT NULL Session Nbr

Prompt Table: AV_RCG_DES_VW1

39 GIFT_NO Character(11) VARCHAR2(11) NOT NULL Gift Nbr

Prompt Table: AV_RCG_DES_VW2

40 RECOGNITION_TYPE Character(1) VARCHAR2(1) NOT NULL Recognition Type

Prompt Table: AV_RCG_DES_VW3

41 DESIGNATION Character(11) VARCHAR2(11) NOT NULL Designation

Prompt Table: AV_RCG_DES_VW5

42 INTV_CD Character(10) VARCHAR2(10) NOT NULL Initiative Code

Prompt Table: %EDITTABLE12

43 AV_AUDIENCE Character(10) VARCHAR2(10) NOT NULL Audience Code

Prompt Table: AV_INITIATE_VW1

44 AUD_TYPE Character(1) VARCHAR2(1) NOT NULL Indicates whether the population is being identified for Segmentation, Reporting, or Administration.
A=Administrative
R=Reporting
S=Segmentation
45 MEMBERSHIP_NBR Character(12) VARCHAR2(12) NOT NULL Membership Number

Prompt Table: AV_MEMBER_VW1

46 AV_MBR_ORG_COD Character(10) VARCHAR2(10) NOT NULL Member Organization Code

Prompt Table: AV_MEMBER_VW2

47 AV_STD_BEN Character(6) VARCHAR2(6) NOT NULL Standard Benefit

Prompt Table: AV_MBR_BNFT_VW2

48 MBR_PMT_NO Character(11) VARCHAR2(11) NOT NULL Member Payment Number

Prompt Table: AV_MBR_BNFT_VW1

49 LN_APPL_ID Character(21) VARCHAR2(21) NOT NULL Loan Application ID
50 SSF_IHC_COVER_NBR Number(3,0) SMALLINT NOT NULL Coverage Number

Prompt Table: SSF_IHC_STDPAR

51 SAD_INT_CONTR_NLD Character(16) VARCHAR2(16) NOT NULL Internal contract

Prompt Table: SAD_BPV_COMM_VW

52 SAD_CONTRACTNR_NLD Number(12,0) DECIMAL(12) NOT NULL Unique OWO contract number.

Prompt Table: SAD_OWO_COMM_VW

53 SAD_PB_CAS_NUMBER Character(14) VARCHAR2(14) NOT NULL CAS Number

Prompt Table: SAD_PB_CASNBRVW

54 SSR_RS_CANDIT_ID Character(11) VARCHAR2(11) NOT NULL Candidate EMPLID

Prompt Table: SSR_RS_CANDIDVW

55 SSR_RS_CANDIT_NBR Character(12) VARCHAR2(12) NOT NULL Last Candidate Number

Prompt Table: SSR_RS_CNDNBRVW

56 SSR_RS_SUBMSSN_NBR Number(3,0) SMALLINT NOT NULL This field indicates the number of times the thesis has been resubmitted for examination

Prompt Table: SSR_RS_SBMNBRVW

57 SSR_RS_TOPIC_SEQ Number(3,0) SMALLINT NOT NULL This field is used to create a unique key when multiple topics exist for a research project.

Prompt Table: SSR_RS_TOPSEQVW

58 SSR_RS_SUPER_NBR Number(3,0) SMALLINT NOT NULL Last Candidate Number

Prompt Table: SSR_RS_SUPNBRVW

59 SSR_RS_RQUIRE_TYPE Character(2) VARCHAR2(2) NOT NULL Field to hold Research Assignment Types

Prompt Table: SSR_RS_OTRQTYVW

60 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr

Prompt Table: STDNT_ENRL_L_VW

61 SCC_TRGR_STATUS Character(1) VARCHAR2(1) NOT NULL Trigger Status
C=Cancelled
E=Error
I=In Process
P=Processed
S=Suspense
U=Unprocessed
62 TRGR_SOURCE Character(1) VARCHAR2(1) NOT NULL Trigger source
B=Batch
O=Online
U=User Input

Default Value: U

63 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
64 COMM_ID Character(11) VARCHAR2(11) NOT NULL Person responsible for the communication
65 COMMENT_PRINT_FLAG Character(1) VARCHAR2(1) NOT NULL Print Comments for Communications

Y/N Table Edit

Default Value: N

66 COMM_COMMENTS Long Character(2000) VARCHAR2(2000) Communication Comments