GRAS DB: Update structure and content of gras.pci_indicator

casesp
Jan 18 2017 14:41

Edit

6

Release

GRAS: 1.0

--

casesp
Jan 13 2017 09:41

Edit

4

Revert state of Field(s) back to this Version

Description

Change the GRAS schema table d_pci_indicator_ratings as follows:

1) Change the data type of column choice_label from small int to VarChar()

2) Add three (3) new rows to the table, highlighted in yellow in the attached spreadsheet.

3) Pass these changes on to NRCS via Christine Whitely.¶

¶

[d_pci_indicator_ratings.xlsx|https://alm.engr.colostate.edu/cb/displayDocument/d_pci_indicator_ratings.xlsx?task_id=29368&artifact_id=26787]¶

¶

[Update GRAS PCI Indicator Ratings Table.01-11-2016.sql|CB:/displayDocument/Update%20GRAS%20PCI%20Indicator%20Ratings%20Table.01-11-2016.sql?doc_id=Update%20GRAS%20PCI%20Indicator%20Ratings%20Table.01-11-2016.sql]

Show diff

Change the GRAS schema table d_pci_indicator_ratings as follows:

1) Change the data type of column choice_label from small int to VarChar()

2) Add three (3) new rows to the table, highlighted in yellow in the attached spreadsheet.

[d_pci_indicator_ratings.xlsx|CB:/displayDocument/d_pci_indicator_ratings.xlsx?task_id=29368&artifact_id=26787]

Comments/Attachments

Update GRAS PCI Indicator Ratings Table.01-11-2016.sql

--

casesp
Jan 13 2017 09:32

Edit

2

No changes.

Tracker:	Requests	Priority:	High	Status:	Resolved
Resolution:	Implemented	Release:	GRAS: 1.0	Assigned to:	casespJan 13 2017 09:32
Submitted by:	casespJan 13 2017 09:32	Modified by:	casespJan 18 2017 14:41	Severity:	--
Service Context:	--

New	Jan 13 2017 09:32
Submit	by casesp

Resolved	Jan 13 2017 09:32
Resolve	by casesp

GRAS DB: Update structure and content of gras.pci_indicator_ratings[CRQ-29368]