Skip to content

xpms.v_sheet_access_grid

View

The Playbook Access Grid sheet as the database holds it: one row per source row, computed columns reproduced in SQL.

Columns of xpms.v_sheet_access_grid
ColumnTypeNullableDescription
source_rowintegerYesRow number in the source sheet.
record_idtextYesRECORD ID (column A), field.
organizationtextYesORGANIZATION (column B), field.
project_idtextYesPROJECT ID (column C), field.
departmenttextYesDEPARTMENT (column D), field.
categorytextYesCATEGORY (column E), field.
sub_categorytextYesSUB CATEGORY (column F), field.
credentialtextYesCREDENTIAL (column G), field.
access_pointtextYesACCESS POINT (column H), field.
access_leveltextYesACCESS LEVEL (column I), field.
capacitytextYesCAPACITY (column J), field.
statustextYesSTATUS (column K), field.
flagtextYesFLAG (column L), field.
notestextYesNOTES (column M), field.
created_bytextYesCREATED BY (column N), field.
created_attextYesCREATED AT (column O), field.
updated_attextYesUPDATED AT (column P), field.