System Views

The following table provides the information you need to modify a borrower application’s system views when sharing data among applications. See the “Shared Data” section of the Application Options chapter in the VPM Enterprise User’s Guide. Unless otherwise noted each view includes and updates all fields in its source table.

 

View Name

Filter

Order By

Update Criteria

ActivityReport_V (SVPM_V.DBC)

 

tDateTime (ascending)

Read-Only

Activity_V (SVPM_V.DBC)

 

 

Key fields: cPK

ActivityForm_V (SVPM_V.DBC)

cUser LIKE ?FINDcUser AND cOrigin LIKE ?FINDcOrigin AND tDateTime >= ?FINDFrom_tMin AND tDateTime < ?FINDTo_tMax

 

Key fields: cPK

AdminTools2_V (SVPM_V.DBC)

 

 

Key fields: cID

AuditReport_V (SDATA_V.DBC)

 

tDateTime (descending)

Read-Only

Audit_V (SDATA_V.DBC)

 

 

Key fields: cPK

AuditForm_V (SDATA_V.DBC)

cUser LIKE ?FINDUser AND cOrigin LIKE ?FINDOrigin AND tDateTime >= ?FINDFrom_tMin AND tDateTime < ?FINDTo_tMax

 

Key fields: cPK

ConditionDetail_V (SVPM_V.DBC)

cPK LIKE ?PKValue AND cFK_Conditions LIKE ?ParentPKValue AND cFormOrReportName LIKE ?GETcFormOrReportName AND cUser LIKE ?GETcUser

nFieldOrder (ascending)

Key fields: cPK

ConditionFields_V (SVPM_V.DBC)

cPK LIKE ?PKValue AND cFormOrReportName LIKE ?GETcFormOrReportName AND cUser LIKE ?GETcUser AND nRelatedPagesPageNumber >= ?GETnRelatedPagesPageNumber_nMin AND nRelatedPagesPageNumber < ?GETnRelatedPagesPageNumber_nMax

nFieldOrder (ascending)

Key fields: cPK

Conditions_V (SVPM_V.DBC)

cPK LIKE ?PKValue AND cFormOrReportName LIKE ?GETcFormOrReportName AND nRelatedPagesPageNumber >= ?GETnRelatedPagesPageNumber_nMin AND nRelatedPagesPageNumber < ?GETnRelatedPagesPageNumber_nMax

cName (ascending)

Key fields: cPK

ConditionsCK_V (SVPM_V.DBC)

cName+cFormOrReportName+cUser LIKE ?CandidateValue

 

Read-Only

Selected fields: cPK, cFormOrReportName, cName, cUser

ControlPermission GroupsForm_V (SVPM_V.DBC)

cCode LIKE ?FINDcCode

 

Key fields: cPK

ControlPermission GroupsFormCK_V (SVPM_V.DBC)

cCode LIKE ?CandidateValue

 

Read-Only

Selected fields: cPK, cCode

ControlSecurityForms_V (SVPM_V.DBC)

 

 

Read-Only

DDCK_V (SDATA_V.DBC)

cPK LIKE ?PKValue AND cFK_DDTV LIKE ?ParentPKValue

 

Key fields: cPK

DDD_V (SDATA_V.DBC)

cPK LIKE ?PKValue AND cName LIKE ?GETcName AND nType >= ?GETnType_nMin AND nType < ?GETnType_nMax

cName (ascending)

Key fields: cPK

DDDS_V (SDATA_V.DBC)

 

cName (ascending)

Key fields: cPK

DDF_V (SDATA_V.DBC)

cPK LIKE ?PKValue AND cFK_DDTV LIKE ?ParentPKValue AND cName LIKE ?GETcName

cName (ascending)

Key fields: cPK

DDFFKS_V (SDATA_V.DBC)

cFK_DDTV_RIRefTV LIKE ?GETcFK_DDTV_RIRefTV AND nIntegrityType = 3 AND nRIBypass = 0

 

Read-Only

Selected fields: cPK, cFK_DDIT_RIFKTag, cFK_DDTV, cFK_DDTV_RIRefTV, cName, mViewSourceDatabase, mViewSourceTable, nRIDeleteRule and nRIUpdateRule from SDATADDF; cPK, cFK_DDD, cDescription, cName and nSourceType from SDATADDTV (cPK joined to DDF.cFK_DDTV); cPK and cName from SDATADDD (cPK joined to DDTV.cFK_DDD)

DDFFKReport_V (SDATA_V.DBC)

nIntegrityType = 3 AND nRIBypass = 0

cName_c + cName_b + cName_a

Read-Only

Selected fields: cName, nRIDeleteRule and nRIUpdateRule from SDATADDF; cName and nSourcetype from SDATADDTV (cPK joined to DDF.cFK_DDTV); cName from SDATADDD (cPK joined to DDTV.cFK_DDD); cName and nSourceType from SDATADDTV (cPK joined to DDF.cFK_DDTV_RIRefTV); cName from SDATADDD (cPK joined to cFK_DDD)

DDFH_V (SDATA_V.DBC)

cPK LIKE ?PKValue AND cFK_DDF LIKE ?ParentPKValue

 

Key fields: cPK

DDFHReport_V (SDATA_V.DBC)

LEN(mVPMHelpText) > 0

cName_c + cName_b + cName_a

Read-Only

Selected fields: mVPMHelpText from SDATADDFH; cDescriptionLong and cName from SDATADDF (cPK joined to DDFH.cFK_DDF); cName from SDATADDTV (cPK joined to DDF.cFK_DDTV); cName from SDATADDD (cPK joined to DDTV.cFK_DDD

DDFP_V (SVPM_V.DBC)

cPK LIKE ?PKValue AND cFK_DDF LIKE ?ParentPKValue AND cID LIKE ?GETcID

 

Key fields: cPK

FieldPermission GroupsForm_V (SVPM_V.DBC)

cCode LIKE ?FINDcCode

 

Key fields: cPK

FieldPermission GroupsFormCK_V (SVPM_V.DBC)

cCode LIKE ?CandidateValue

 

Read-Only

Selected fields: cPK, cCode

DDGK_V (SDATA_V.DBC)

cPK LIKE ?PKValue AND cFK_DDF LIKE ?ParentPKValue

 

Key fields: cPK

DDIT_V (SDATA_V.DBC)

cPK LIKE ?PKValue AND cFK_DDTV LIKE ?ParentPKValue AND cName LIKE ?GETcName

cName (ascending)

Key fields: cPK

DDITPK_V (SDATA_V.DBC)

cFK_DDTV LIKE ?ParentPKValue AND nPrimary = 1

 

Key fields: cPK

DDSI_V (SDATA_V.DBC)

cPK LIKE ?PKValue AND cFK_DDF LIKE ?ParentPKValue

nNaturalOrder (ascending)

Key fields: cPK

DDTV_V (SDATA_V.DBC)

cPK LIKE ?PKValue AND cFK_DDD LIKE ?ParentPKValue AND cName LIKE ?GETcName AND cLToR_RemoteView LIKE ?GETcLToR_RemoteView AND cLToR_RemoteViewDBC LIKE ?GETcLToR_RemoteViewDBC AND nSourceType >= ?GETnSourceType_nMin AND nSourceType <= ?GETnSourceType_nMax

cName (ascending)

Key fields: cPK

Errors_V (SDATA_V.DBC)

cUser LIKE ?GETcUser

 

Key fields: cPK

ErrorsForm_V (SDATA_V.DBC)

cUser LIKE ?FINDUser AND cOrigin LIKE ?FINDOrigin AND tDateTime >= ?FINDFrom_tMin AND tDateTime < ?FindTo_tMax

 

Key fields: cPK

ErrorsReport_V (SDATA_V.DBC)

 

tDateTime (descending)

Read-Only

 

Languages_V (SVPM_V.DBC)

 

 

Key fields: cPK

Languages_Picklist_V (SVPM_V.DBC)

NOT cLanguageID == “ML”

 

Read-Only

Selected fields: cPK, cLanguageID, cDescription

Languages_Picklist2_V (SVPM_V.DBC)

cLanguageID LIKE ?PKValue

 

Read-Only

Selected fields: cLanguageID, cDescription

LanguagesCK_V (SVPM_V.DBC)

cLanguageID LIKE ?CandidateValue

 

Read-Only

Selected fields: cPK, cLanguageID

MenuOptions_V (SVPM_V.DBC)

 

 

Read-Only

 

MenuPermission GroupsForm_V (SVPM_V.DBC)

cCode LIKE ?FINDcCode

 

Key fields: cPK

MenuPermission GroupsFormCK_V (SVPM_V.DBC)

cCode LIKE ?CandidateValue

 

Read-Only

Selected fields: cPK, cCode

Messages_V (SVPM_V.DBC)

 

 

Key fields: cPK

MessagesCK_V (SVPM_V.DBC)

cMessageID LIKE ?CandidateValue

 

Read-Only

Selected fields: cPK, cMessageID

MessageTranslations_V (SVPM_V.DBC)

 

 

Key fields: cPK

Selected fields: cPK, cFK_Languages, cFK_Messages, nExpression and mText from SVPMMESSAGETRANSLATIONS; cLanguageID from SVPMLANGUAGES (cPK joined to cFK_Languages); cMessageID from SVPMMESSAGES (cPK joined to cFK_Messages)

Updateable fields: All selected fields in SVPMMESSAGETRANSLATIONS

MessageTranslationsCK_V (SVPM_V.DBC)

cFK_Languages+cFK_Messages LIKE ?CandidateValue

 

Read-Only

Selected fields: cPK, cFK_Languages, cFK_Messages

Reports_V (SVPM_V.DBC)

cReportOrLabelName LIKE ?GETcReportOrLabelName AND cType LIKE  ?GETcType

 

Key fields: cPK

ReportsCK_V (SVPM_V.DBC)

cReportOrLabelName+cType LIKE ?CandidateValue

 

Read-Only

Selected fields: cPK, cReportOrLabelNames, cType

SecurityData_V (SVPM_V.DBC)

 

 

Key fields: cData

Strings_V (SVPM_V.DBC)

 

 

Key fields: cPK

StringsCK_V (SVPM_V.DBC)

cStringID+cUseID LIKE ?CandidateValue

 

Read-Only

Selected fields: cPK, cStringID, cUseID

StringTranslations_V (SVPM_V.DBC)

 

 

Key fields: cPK

Selected fields: cPK, cFK_Languages, cFK_Strings, nExpression and mText from SVPMSTRINGTRANSLATIONS; cLanguageID from SVPMLANGUAGES (cPK joined to cFK_Languages); cStringID and cUseID from SVPMSTRINGS (cPK joined to cFK_Strings)

Updateable fields: All selected fields in SVPMSTRINGTRANSLATIONS

StringTranslationsCK_V (SVPM_V.DBC)

cFK_Languages+cFK_Strings LIKE ?CandidateValue

 

Read-Only

Selected fields: cPK, cFK_Languages, cFK_Strings

ToolbarControls_V

(SVPM_V.DBC)

 

 

Key fields: cID

UserForm_V (SDATA_V.DBC)

 

 

Key fields: cData

UserLogin_V (SDATA_V.DBC)

SUBSTR(cData,5,20) LIKE ?cID

 

Key fields: cData

More:

Application Main Program