Question3Replies224Views×Close popoverDyan Baur (DyanG412) Hawaii Medical Service Association Hawaii Medical Service Association US View Profile DyanG412 Member since 2013 212 posts Hawaii Medical Service Association Posted: February 27, 2017Last activity: August 26, 2020Posted: 27 Feb 2017 6:50 ESTLast activity: 26 Aug 2020 8:41 EDT Closed Solved "PCO" in SQL statementPRPC uses "PCO"."ColumName" as "Property Name" syntax in the sql statement. What is the keyword "PCO" and what PRPC requires it for?×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! Moderation Team has archived post This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question. Posted: 3 years agoUpdated: 3 years agoPosted: 27 Feb 2017 7:07 ESTUpdated: 27 Feb 2017 7:06 EST×Close popoverMarc Alderman (Marc Alderman) PEGA Senior Software Solutions Engineer PEG GB View ProfileMarc Alderman PEGA replied to DyanG412PCO is just an alias in the query for whichever table is being selected from. See some examples here. https://www.w3schools.com/sql/sql_alias.asp Accepted Solution Posted: 3 years agoPosted: 27 Feb 2017 7:25 EST×Close popoverHaritha Damarla (Haritha12) PEGA Technical Solutions Engineer Pegasystems Inc. IN View ProfileHaritha12 PEGA replied to DyanG412Hi, I believe it is just an alias to the table name, created by prpc internally , to look the query more readable as SELECT "PC0".PropA AS "PropA" , "PC0".pzInsKey AS "pzInsKey" FROM dbo.pc_Sae_HRServices_Work "PC0" WHERE "PC0".pxObjClass = 'Sae-HRServices-Work-ABC' When we execute a report, to a main table, the alias will be maintained as PCO. If we use joins, join prefix will be used as an alias name. Posted: 3 years agoPosted: 27 Feb 2017 7:19 EST×Close popoverSandeep Gunanchipalli (Sandeep46) OCBC Bank Senior Software Analyst OCBC Bank SG View ProfileSandeep46 OCBC Bank replied to DyanG412Hi, PC0 is just an Alias for table name. For many Databases, Tables might needs to be called/identified using Schema name(Schema_NAME.TableName). As per my understanding, For using column names, it is easier to use "PC0".ColumName(Alias for table) rather than calling Schemaname.TableName.cloumn name(Schema name wont be same for all customers).