Wen-

Thanks for getting back to me. You're summary of the problem is correct.

Here is the table with the XML column that I referenced in my original post:

CREATE TABLE [dbo].[InProgress]
(
    [InProgressID] [uniqueidentifier] NOT NULL,
    [DeviceID] [varchar](50) NULL,
    [ResponseXML] [xml] (CONTENT dbo.MasterResponse) NULL,
    [RestoreFlag] [bit] NOT NULL,
    [InsertDate] [datetime] NOT NULL,
    [InsertBy] [varchar](128) NOT NULL,
    [UpdateDate] [datetime] NULL,
    [UpdateBy] [varchar](128) NULL,
    [HarvestUnitNumber] [varchar](50) NULL,
    [Unit] [varchar](50) NULL CONSTRAINT [DF_InProgress_Unit]  DEFAULT
('Unknown'),
    [TotalAcres] [decimal](18, 2) NULL CONSTRAINT [DF_InProgress_TotalAcres]  
DEFAULT ((0.00)),
    [ContractorID] [int] NULL,
    [Contractor] [varchar](50) NULL,
    [Crew] [varchar](50) NULL,
    [Org] [int] NULL,
    [RowVersion] [timestamp] NOT NULL,
    CONSTRAINT [PK_InProgress] PRIMARY KEY CLUSTERED
    (
        [InProgressID] ASC
    )
    WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY =
OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY];

And here is one of the views created over this table:

CREATE VIEW [dbo].[ActionView]
AS

WITH
XMLNAMESPACES('http://www.companyname.com/Schemas/CPI/MasterResponse.xsd' AS
PC)

SELECT     InProgressID,
ISNULL(resp.items.value('(PC:ActionID)[1]', 'varchar(50)'), '') AS ActionID,
ISNULL(resp.items.value('(PC:InspectionID)[1]', 'varchar(50)'), '') AS
InspectionID,
ISNULL(resp.items.value('(PC:InspectionNumber)[1]', 'smallint'), 0) AS
InspectionNumber,
ISNULL(resp.items.value('(PC:TypeOfConsideration)[1]', 'varchar(50)'), '')
AS TypeOfConsideration,
ISNULL(resp.items.value('(PC:Action)[1]', 'varchar(128)'), '') AS Action,
ISNULL(resp.items.value('(PC:Rating)[1]', 'smallint'), 0)  AS Rating,
ISNULL(resp.items.value('(PC:InsertDate)[1]', 'datetime'), '12:00:00AM') AS
InsertDate,
ISNULL(resp.items.value('(PC:InsertBy)[1]', 'varchar(128)') , '')AS InsertBy,
ISNULL(resp.items.value('(PC:UpdateDate)[1]', 'datetime'), '12:00:00AM') AS
UpdateDate,
ISNULL(resp.items.value('(PC:UpdateBy)[1]', 'varchar(128)'), '') AS UpdateBy

    FROM         [dbo].[InProgress] CROSS
    APPLY ResponseXML.nodes('/PC:MasterResponse/PC:Action')
    AS resp(items)

All tables are located in the Database project in Schema Objects > Tables.
All views are located in Schema Objects > Views.

If there's any other information you need, please let me know.

Thanks very much.