👉 When we create an application and under application we create case types ( one.. many) all the case types are stored in Work Class. Work class is referred to as the class group or Work pool

👉 All the case data that are produced by case types under work class are stored in a "Single" table. To prove this: Right click the case type class in app explorer -> view definition -> Test Connection

Class CIT-ABCRecru-Work-InterviewReadiness is mapped to table pegadata.pc_CIT_ABCRecru_Work in PegaDATA. Class CIT-ABCRecru-Work-NewRecruitment is mapped to table pegadata.pc_CIT_ABCRecru_Work in PegaDATA.

Database available in pega are : PegaData, CustomerData, PegaData Reporting, PegaRULES which database contains the case data ?PegaData inside the PegaData Database which table stores the data ? pc_org_appname_work eg: pc_CIT_ABCRecru_Work

How Data gets Stored?

User Form ————> Clipboard——————> DB

From the user form it will be first stored in clipboard. from the clipboard it will move into Data base table. All the casetypes data are stored in one table.

As you can see in the above fig, some of the properties are null, that is because it wass accesing other casetypes. To avoid null type in DB table pega uses BLOB (Binary Large Object) which can accept any amount of Data.

this pzPVStream column is a binary column of BLOB (Binary Large Object) Binary is a special data type in the database that has an unlimited storage size.

Types Of Reports: (3 sets)

First Set :

1. Business reports -- report which are created only using the user defined metrics or business metrics ie. properties defined by the user / data entered by the user at run time.
2. Process Reports -- report which are created only using the pega defined properties. Pega defined properties start with px, py and pz. those reports are called as process reports.

Filter Conditions:

Placement head wants to view only the student details of the ECE department use Filter conditions.

Filter Condition: F1 .Department EqualTo "ECE"(param.dept—> for custom filter)