Table Description
Crovo, Roseanne
Does anyone know the 3 character “code” to use for ADM_SOURCE in order to pull the table description? Is there any easy way to find them?
TBLDESC("???",ADM_SOURCE)
Roseanne Crovo, Solutions Development Lead | Ascension Health Information Services | Office: 205.939.7997 | Cell: 205.602.4813
CONFIDENTIALITY NOTICE:
This email message and any accompanying data or files is confidential and may contain privileged information intended only for the named recipient(s). If you are not the intended recipient(s), you are hereby notified that the dissemination, distribution, and or copying of this message is strictly prohibited. If you receive this message in error, or are not the named recipient(s), please notify the sender at the email address above, delete this email from your computer, and destroy any copies in any form immediately. Receipt by anyone other than the named recipient(s) is not a waiver of any attorney-client, work product, or other applicable privilege.
Kimberly Core
Try ADS
Kimberly Core | Support Analyst | Consolidated Health Information Services | (519) 352-6401 x6971 | Kim....@consolidatedhealth.ca
CONFIDENTIALITY STATEMENT: This email transmission may contain confidential or legally privileged information that is intended only for the individual or entity named in the email address. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or reliance upon the contents of this email is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return email and delete this message and any attachments from your system.
P Please ~ only print this email if necessary! Reduce, Reuse, Recycle!
--
You received this message because you are subscribed to the Google Groups "hisnet" group.
To post to this group, send email to his...@googlegroups.com.
To unsubscribe from this group, send email to
hisnet+un...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/hisnet?hl=en.
Crovo, Roseanne
That was it. Thanks!
Sally D. Hanks
You can create this little query and have a file of the codes available:
SET FILE = ‘C:\table_cds.xls’
SET FORMAT = ‘TAB’
SET COLUMN_HEADINGS ON
SELECT DISTINCT TBL_CD HEADING ‘CODE’
,TYPE_LINK@TBL_HEADING HEADING ‘DESCRIPTION’
FROM AG_TABLE
From: his...@googlegroups.com [mailto:his...@googlegroups.com]
On Behalf Of Crovo, Roseanne
Sent: Monday, October 15, 2012 12:10 PM
To: his...@googlegroups.com
Subject: Table Description
Does anyone know the 3 character “code” to use for ADM_SOURCE in order to pull the table description? Is there any easy way to find them?
--
Judi Spillers
QBMIS_TABLE_LISTING_BY_NAME
Created: 12/15/04 Programmer: Judi Spillers
Query Purpose: Provide a listing of the contents of any Star table by
entering the table name
Variables Used: :XCODE Table code, :XACT Flag to include only actives
*/
SET FORMAT = 'COMMA'
SET FILE = 'c:\Star table.csv'
SET COLUMN_HEADINGS ON
READ :XNAME CHAR(20) PROMPT 'Enter partial table name'
READ :XACT CHAR(3) PROMPT 'Include Active, Inactive or ALL (A,I,ALL)?'
DEFAULT 'ALL'
SELECT NULL
FROM AG_TABLE A,
AG_TABLE_TYPE B
WHERE A.TBL_CD = B.TBL_CD
AND UPPER(B.TBL_HEADING) [ UPPER(:XNAME)
ORDER BY B.TBL_HEADING, A.CD_DESC
BREAK AT B.TBL_HEADING
WRITE B.TBL_CD|'-'|B.TBL_HEADING
DETAIL
IF :XACT = 'ALL'
WRITE A.CD_NBR HEADING 'CD_NBR' COLUMN 2
, A.CD_DESC HEADING 'CD_DESC' COLUMN 10
, A.ACT_IND HEADING 'ACTIVE?' COLUMN 50
, A.FAC HEADING 'FAC'
ENDIF
IF :XACT = 'A'
IF A.ACT_IND = 'Yes'
WRITE A.CD_NBR HEADING '' COLUMN 2
, A.CD_DESC HEADING '' COLUMN 10
, A.ACT_IND HEADING '' COLUMN 50
, A.FAC HEADING ''
ENDIF
ENDIF
IF :XACT = 'I'
IF A.ACT_IND = 'No'
WRITE A.CD_NBR HEADING '' COLUMN 2
, A.CD_DESC HEADING '' COLUMN 10
, A.ACT_IND HEADING '' COLUMN 50
ENDIF
ENDIF
Does anyone know the 3 character "code" to use for ADM_SOURCE in order to pull the table description? Is there any easy way to find them?
TBLDESC("???",ADM_SOURCE)
Roseanne Crovo, Solutions Development Lead | Ascension Health Information Services | Office: 205.939.7997 | Cell: 205.602.4813
CONFIDENTIALITY NOTICE:
This email message and any accompanying data or files is confidential and may contain privileged information intended only for the named recipient(s). If you are not the intended recipient(s), you are hereby notified that the dissemination, distribution, and or copying of this message is strictly prohibited. If you receive this message in error, or are not the named recipient(s), please notify the sender at the email address above, delete this email from your computer, and destroy any copies in any form immediately. Receipt by anyone other than the named recipient(s) is not a waiver of any attorney-client, work product, or other applicable privilege.
--You received this message because you are subscribed to the Google Groups "hisnet" group.
To post to this group, send email to his...@googlegroups.com.
To unsubscribe from this group, send email to hisnet+un...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/hisnet?hl=en.
#####################################
This message is for the named person's use only. It may
contain private, proprietary, or legally privileged information.
No privilege is waived or lost by any mistransmission. If you
receive this message in error, please immediately delete it and
all copies of it from your system, destroy any hard copies of it,
and notify the sender. You must not, directly or indirectly, use,
disclose, distribute, print, or copy any part of this message if you
are not the intended recipient. Health First reserves the right to
monitor all e-mail communications through its networks. Any views
or opinions expressed in this message are solely those of the
individual sender, except (1) where the message states such views
or opinions are on behalf of a particular entity; and (2) the sender
is authorized by the entity to give such views or opinions.
#####################################
Marcus Gervais
Sr. Clinical Analyst
Trinity Information Services -Fresno
Saint Agnes Medical Center
1303 E. Herndon Ave
Mail Stop # 900
Fresno, CA 93720
Phone 559-450-3156
Cell 559-779-6844
Financial/Clinical App. Support
>>> On 10/15/2012 at 10:15 AM, <Roseann...@ascensionhealth.org> wrote:
|
That was it. Thanks! |
Roseanne Crovo, Solutions Development Lead | Ascension Health Information Services | Office: 205.939.7997 | Cell: 205.602.4813
|
From: his...@googlegroups.com [mailto:his...@googlegroups.com] On Behalf Of Kimberly Core |
|
Try ADS |