Back to Home

P10 Stage Flow

Table of Contents

• Overview
• A
• B
• C
• D
• E
• F
• G
• H
• I
• J
• K
• L
• M
• N
• O
• P
• Q
• R
• S
• T
• U
• V
• W
• X
• Y
• Z
• Notes

Overview

Definition of sql table column names and how its used in the p10 flow process.

A

• AuditID - Tied to InstanceID. See smart.p10_AuditInstance table [SAM_AUDIT] database

B

C

D

• DateClose - last time an audit was updated.
  • smart.p10_AuditInstance table

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

• Scope - A scope is a module: a stored procedure, trigger, function, or batch. Therefore, two statements are in the same scope if they are in the same stored procedure, function, or batch.
• SCOPE_IDENTITY() - is a SQL function.
  • It returns the primary key of the last inserted row, regardless of what table it was inserted into.
  • Only returns values inserted only within the current scope.
  • See [SCOPE IDENTITY] in [Scripts]
• SOP - Standard Operating Procedure

T

U

V

W

X

Y

Z

Notes