Vet Client

Data Source

PROD_DB

Job/Process Source (Refresh Interval)

Live

 

Functional User(s)

Ashley Martinez

Report Owner

Jenny Sae Chao

Contains PII

Yes

What It’s Used For

This report is used for meeting Veterans compliance (Need more info on this)

Options

Options

Description

Options

Description

Term

This populates term codes up until the current term.

Results

Field Name

Data Source/Logic

Description (sample)

Field Name

Data Source/Logic

Description (sample)

Student ID

SPRIDEN_ID

 

Last Name

SPRIDEN_LAST_NAME

 

First Name

SPRIDEN_FIRST_NAME

 

MI

SPRIDEN_MI

 

Vet Chapter

STVVETC_DESC (validation table joined on SGRVETN_VETC_CODE)

 

Vet Cert Hrs

SGRVETN_CERT_HOURS

Certified Hours

Vet Cert Date

SGRVETN_CERT_DATE

Certified Date

Vet Act Date

SGRVETN_ACTIVITY_DATE

Activity Date

Report Domain

 


Version Date Comment
Current Version (v. 1) Apr 10, 2023 21:43 Garrett Woodard