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 |
