The tables below outlines all the fields available within Pentana to map to Retain.
Clients > Clients | |
RetainID |
CLT_ID |
Name |
CLT_DESCR |
Ref |
CLT_REF |
Title |
CLT_TITLE |
Description | CLT_DESCRIPTION |
Active |
CLT_ACTIVE_BIT |
Industry |
CLT_INDUSTRYNAME |
Owner |
CLT_OWNERNAME |
GUID |
CLT_TEXT1 |
Audits > Jobs | |
RetainID |
JOB_ID |
Name |
JOB_DESCR |
Ref |
JOB_REF |
Title |
JOB_TITLE |
Description |
JOB_DESCRIPTION |
ScopeNames |
JOB_SCOPENAMES |
Purpose |
JOB_PURPOSE |
StartMilestone.PlannedDate |
JOB_START |
EndMilestone.PlannedDate |
JOB_END |
StartMilestone.ActualDate |
JOB_ACTUALSTARTDATE |
EndMilestone.ActualDate |
JOB_ACTUALENDDATE |
PlannedEffort |
JOB_PLANNEDEFFORT |
ActualEffort |
JOB_ACTUALEFFORT |
Confidential |
JOB_CONFIDENTIAL_BIT |
ReportMilestone.ActualDate |
JOB_ACTUALREPORTDATE |
Conclusion |
JOB_CONCLUSION |
Client |
JOB_CLIENTNAME |
PlanState |
JOB_PLANSTATENAME |
AuditState |
JOB_AUDITSTATENAME |
Director |
JOB_DIRECTORNAME |
Manager |
JOB_MANAGERNAME |
Leader |
JOB_LEADERNAME |
Type |
JOB_TYPENAME |
Period |
JOB_PERIODNAME |
Rating |
JOB_RATINGNAME |
SignOffState |
JOB_SIGNOFFSTATENAME |
ReportMilestone.PlannedDate |
JOB_PLANNEDREPORTDATE |
OrgUnit1Names |
JOB_ORGUNIT1NAMES |
OrgUnit2Names |
JOB_ORGUNIT2NAMES |
OrgUnit3Names |
JOB_ORGUNIT3NAMES |
OrgUnit4Names |
JOB_ORGUNIT4NAMES |
EntityNames |
JOB_ENTITYNAMES |
ProcessArea1Names |
JOB_PROCESSAREA1NAMES |
ProcessArea2Names |
JOB_PROCESSAREA2NAMES |
ProcessArea3Names |
JOB_PROCESSAREA3NAMES |
ProcessArea4Names |
JOB_PROCESSAREA4NAMES |
ProcessNames |
JOB_PROCESSNAMES |
GUID |
JOB_TEXT1 |
AuditState.ID |
JOB_AUDITSTATEID |
DepartmentNames |
JOB_DEPARTMENTNAMES |
Staff > Resources | |
RetainID |
RES_ID |
Name |
RES_DESCR |
|
RES_EMAIL |
Title |
RES_TITLE |
Forenames |
RES_FORENAMES |
Initials |
RES_INITIALS |
Surname |
RES_SURNAME |
Active |
RES_ACTIVE_BIT |
RoleNames |
RES_ROLENAMES |
DepartmentNames |
RES_DEPARTMENTNAMES |
Job |
RES_JOBNAME |
Type |
RES_TYPENAME |
GUID |
RES_TEXT1 |
StartDate |
RES_SDATE |
EndDate |
RES_EDATE |
RetainUserLogon |
RES_USRLOGON |
RetainUserRole.RetainID |
RES_USR_ID |
Critical Note: This information is intended for use by qualified database administrators only. Any edits made directly within the Pentana SQL database are not supported by Ideagen. It is strongly recommended that a backup of your database is taken before making any changes and that all changes are thoroughly tested.
Article Comments
0 comments