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