Database Table Default Values

Contents Show

RequiredFields Database Table

The default values for the RequiredFields database table are listed below. FieldID is a sequential number. CreateUserID and ModifyUserID will be set to "ENH-389". CreateDttm and ModifyDttm are set to the current system date/time.

In all instances noted, the CertWICStatus and VOCDocument columns of the current certification are used to determine if the control is required. If the VOCDocument value is "Y", the system uses the Certification Type equal to "V" to access the RequiredFields database table. Otherwise the system uses the Certification Type equal to "C" to access the RequiredFields database table.

Feature

WIC Category

Display Text

Certification Type

Required

AuthRepMartStatus

I

Authorized Representative Marital Status

V

Y

AuthRepMartStatus

I

Authorized Representative Marital Status

C

Y

AuthRepMartStatus

C

Authorized Representative Marital Status

V

Y

AuthRepMartStatus

C

Authorized Representative Marital Status

C

Y

AuthRepMartStatus

B

Authorized Representative Marital Status

V

Y

AuthRepMartStatus

B

Authorized Representative Marital Status

C

Y

AuthRepMartStatus

N

Authorized Representative Marital Status

V

Y

AuthRepMartStatus

N

Authorized Representative Marital Status

C

Y

AuthRepMartStatus

P

Authorized Representative Marital Status

V

Y

AuthRepMartStatus

P

Authorized Representative Marital Status

C

Y

AuthRepRegisterToVote

I

Authorized Representative Register to Vote

V

Y

AuthRepRegisterToVote

I

Authorized Representative Register to Vote

C

Y

AuthRepRegisterToVote

C

Authorized Representative Register to Vote

V

Y

AuthRepRegisterToVote

C

Authorized Representative Register to Vote

C

Y

AuthRepRegisterToVote

B

Authorized Representative Register to Vote

V

Y

AuthRepRegisterToVote

B

Authorized Representative Register to Vote

C

Y

AuthRepRegisterToVote

N

Authorized Representative Register to Vote

V

Y

AuthRepRegisterToVote

N

Authorized Representative Register to Vote

C

Y

AuthRepRegisterToVote

P

Authorized Representative Register to Vote

V

Y

AuthRepRegisterToVote

P

Authorized Representative Register to Vote

C

Y

BirthFacility

I

Birth Facility

V

Y

BirthFacility

I

Birth Facility

C

Y

BirthFacility

C

Birth Facility

V

Y

BirthFacility

C

Birth Facility

C

Y

BirthFacility

B

Birth Facility

C

Y

BirthFacility

N

Birth Facility

C

Y

BirthHeight

I

Birth Height

V

Y

BirthHeight

I

Birth Height

C

Y

BirthHeight

C

Birth Height

V

Y

BirthHeight

C

Birth Height

C

Y

NumWICPregnancies

P

Number of WIC Pregnancies

C

Y

|

Appendix