|
|
|
|
|
|
|
|
|
| Previous | Next | Contents | Index | Navigation | Glossary | Library |
| Database item | Description |
|---|---|
| APL_DATE_END | The date the application ended |
| APL_DATE_RECEIVED | The date the application was received |
| Database item | Description |
|---|---|
| ASG_ASSIGNMENT_SEQUENCE | This is used as a default for assignment number |
| ASG_DATE_FROM | The date from which this assignment information is effective |
| ASG_DATE_TO | The date to which this assignment information is effective |
| ASG_EMPLOYMENT_CATEGORY | The employment category for the assignment |
| ASG_END_TIME | The standard end time for the assignment |
| ASG_FREQ | The frequency for which the assignment working hours are measured |
| ASG_GRADE | The employee's grade |
| ASG_GRADE_DATE_FROM | The date from which this assignment grade information is effective |
| ASG_GRADE_DATE_TO | The date to which this assignment grade information is effective |
| ASG_GROUP | The employee's group |
| ASG_HOURS | The standard number of working hours for the assignment |
| ASG_INT_ADDR_LINE | The internal address of the assignment |
| ASG_JOB | The employee's job |
| ASG_JOB_DATE_FROM | The date from which this assignment job information is effective |
| ASG_JOB_DATE_TO | The date to which this assignment job information is effective |
| ASG_LAST_CHANGE_REASON | The reason the salary was changed |
| ASG_LAST_PERFORMANCE_DATE | Last performance review date |
| ASG_LAST_PERFORMANCE_LOCATION | Last performance review location |
| ASG_LAST_PERFORMANCE_RATING | Last performance review rating |
| ASG_LAST_PERFORMANCE_TYPE | Last performance review type |
| ASG_LAST_PROC_PAYROLL_NAME | The payroll name the assignment was last processed |
| ASG_LAST_PROC_PERIOD_ID | The time period ID the assignment was last processed |
| ASG_LAST_PROC_PERIOD_NAME | The period name the assignment was last processed |
| ASG_LAST_PROC_PERIOD_NUMBER | The period number the assignment was last processed |
| ASG_LAST_PROPOSED_SALARY_CHANGE | The proposed salary chage |
| ASG_LAST_PROPOSED_SALARY_PERCENT | The proposed salary change as a percentage |
| ASG_LAST_SALARY_CHANGE_APPROVED | Whether the last proposed salary change has been approved |
| ASG_LAST_SALARY_DATE | The last salary change date |
| ASG_LOCATION | The employee's location |
| ASG_LOC_INACTIVE_DATE | The date to which the location information is effective |
| ASG_MANAGER | Whether the assignment is a managerial assignment (yes/no) |
| ASG_NEXT_PERFORMANCE_DATE | Next performance review date |
| ASG_NEXT_SALARY_DATE | The date of the next salary change |
| ASG_NUMBER | The assignment number |
| ASG_ORG | The employee's organization |
| ASG_ORG_DATE_FROM | The date from which assignment organization information is effective |
| ASG_ORG_DATE_TO | The date to which assignment organization information is effective |
| ASG_PAYROLL | The employee's payroll |
| ASG_PERFORMANCE_REVIEW_FREQUENCY | The performance review frequency for the assignment |
| ASG_PERFORMANCE_REVIEW_PERIOD | The performance review frequency for the assignment |
| ASG_PER_STATUS_DP | Personal status for the assignment (as of Date Paid) |
| ASG_POSITION | The employee's position |
| ASG_POS_DATE_FROM | The date from which this assignment position information is effective |
| ASG_POS_DATE_TO | The date to which this assignment position information is effective |
| ASG_POS_END_TIME | The standard end time for the assignment position |
| ASG_POS_FREQ | The frequency for which the assignment position's hours is measured |
| ASG_POS_HOURS | The standard number of working hours for the position |
| ASG_POS_PROB_PERIOD | The probation period for the assignment position |
| ASG_POS_START_TIME | The standard start time for the assignment position |
| ASG_PRIMARY | Whether this is the employee's primary assignment (yes/no) |
| ASG_PROB_END_DATE | The probation period end date |
| ASG_PROB_PERIOD | The assignment's probation period |
| ASG_PROB_UNITS | The units of the assignment's probation period |
| ASG_REC_FULL_NAME | The full name for the recruiter |
| ASG_RELIEF | The relief position if the current position holder is absent |
| ASG_SALARY | The current salary for an employee |
| ASG_SALARY_BASIS | The payment basis (i.e. frequency) for the assignment, e.g. monthly |
| ASG_SALARY_BASIS_CODE | The payment basis lookup code for the assignment |
| ASG_SALARY_BASIS_NAME | The salary basis name for the assignment |
| ASG_SALARY_ELEMENT | The display element name |
| ASG_SALARY_ELEMENT_VALUE_NAME | The display input value name |
| ASG_SALARY_GRADE_RATE | The display rate name |
| ASG_SALARY_RATE_BASIS | The salary rate basis |
| ASG_SALARY_REVIEW_FREQUENCY | The salary review frequency for the assignment |
| ASG_SALARY_REVIEW_PERIOD | The salary review period for the assignment |
| ASG_START_DATE | The start date of the assignment |
| ASG_START_TIME | The standard start time for the assignment |
| ASG_STATUS | The primary status for the assignment |
| ASG_SUCCESSOR | The position name that will succeed into this position |
| ASG_SUP_FULL_NAME | The full name for the supervisor |
| ASG_TYPE | Whether this is an employee or applicant assignment |
| ASG_VACANCY | The name of the vacancy applied for |
| Database item | Description |
|---|---|
| CON_ADR_CITY | The name of the contact's town or city |
| CON_ADR_COUNTRY | The name of the contact's country |
| CON_ADR_DATE_FROM | The first date on which the contact can be contacted |
| CON_ADR_DATE_TO | The last date on which the contact can be contacted |
| CON_ADR_LINE_1 | The first line of the contact's address |
| CON_ADR_LINE_2 | The second line of the contact's address |
| CON_ADR_LINE_3 | The third line of the contact's address |
| CON_ADR_PHONE_1 | The contact's first telephone number |
| CON_ADR_PHONE_2 | The contact's second telephone number |
| CON_ADR_PHONE_3 | The contact's third telephone number |
| CON_ADR_POSTAL_CODE | The contact's postal code |
| CON_ADR_REGION_1 | The first line of the contact's region |
| CON_ADR_REGION_2 | The second line of the contact's region |
| CON_ADR_REGION_3 | The third line of the contact's region |
| Database item | Description |
|---|---|
| CON_AGE | The contact's age |
| CON_APP_NUMBER | The contact's applicant number |
| CON_CURRENT_APP | Whether the contact is a current applicant (yes/no) |
| CON_CURRENT_EMP | Whether the contact is a current employee (yes/no) |
| CON_DATE_OF_BIRTH | The contact's date of birth |
| CON_DISABLED | Whether the contact is disabled (yes/no) |
| CON_EMP_NUMBER | The contact's employee number |
| CON_END_DATE | The date to which this contact information is effective |
| CON_FIRST_NAME | The contact's first name |
| CON_FULL_NAME | The contact's full name |
| CON_KNOWN_AS | The contact's preferred name |
| CON_LAST_NAME | The contact's last name |
| CON_MARITAL_STATUS | The contact's marital status |
| CON_MIDDLE_NAMES | The contact's middle names |
| CON_NATIONALITY | The contact's nationality |
| CON_PERSON_TYPE | The contact's person type - employee or applicant, for example |
| CON_RELATIONSHIP | The relationship of the contact to the employee |
| CON_SEX | The contact's sex |
| CON_START_DATE | The date from which this contact information is effective |
| CON_TITLE | The contact's title |
| CON_WORK_PHONE | The contact's work telephone number |
| Database item | Description |
|---|---|
| EMP_HIRE_DATE | The employee's hire date |
| EMP_LAST_PROCESS_DATE | The date the employee was last processed |
| EMP_LEAVING_REASON | The reason the employee left |
| EMP_TERM_ACCEPTED_BY | The person who accepted the employee's notice |
| EMP_TERM_DATE | The employee's termination date |
| Database item | Description |
|---|---|
| LOC_ADR_LINE_1 | The first line os the assignment's work address |
| LOC_ADR_LINE_2 | The second line of the assignment's work address |
| LOC_ADR_LINE_3 | The third line of the assignment's work address |
| LOC_ADR_POSTAL_CODE | The postal code for the assignment's work address |
| LOC_ADR_REGION_1 | The first line of the assignment's region |
| LOC_ADR_REGION_2 | The second line of the assignment's region |
| LOC_ADR_REGION_3 | The third line of the assignment's region |
| LOC_ADR_PHONE_1 | The assignment's first work telephone number |
| LOC_ADR_PHONE_2 | The assignment's second work telephone number |
| LOC_ADR_PHONE_3 | The assignment's third work telephone number |
| LOC_ADR_CITY | The town or city where the assignment works |
| LOC_ADR_COUNTRY | The country where the assignment works |
| Database item | Description |
|---|---|
| LOC_ADR_US_COUNTY | The assignment's work county (US only) |
| LOC_ADR_US_STATE | The assignment's work state (US only) |
| LOC_ADR_US_STATE_CODE | The assignment's work state code (US only) |
| Database item | Description |
|---|---|
| LOC_ADR_UK_COUNTY | The assignment's work county (UK only) |
| Database item | Description |
|---|---|
| PAY_PERIODS_PER_YEAR | The number of pay periods in the year |
| PAY_PROC_PERIOD_CUT_OFF_DATE | The cut off date for the payroll period |
| PAY_PROC_PERIOD_DATE_PAID | The date the payroll was paid |
| PAY_PROC_PERIOD_DIRECT_DEPOSIT_DATE | The direct deposit date for the payroll period |
| PAY_PROC_PERIOD_END_DATE | The end date of the payroll period |
| PAY_PROC_PERIOD_ID | The ID of the time period for the payroll |
| PAY_PROC_PERIOD_NAME | The period name for the payroll |
| PAY_PROC_PERIOD_NUMBER | The current period number for the payroll |
| PAY_PROC_PERIOD_PAY_ADVICE_DATE | The pay advice date for the payroll period |
| PAY_PROC_PERIOD_START_DATE | The start date of the payroll period |
| Database item | Description |
|---|---|
| PER_ADR_CITY | The name of the person's town or city |
| PER_ADR_COUNTRY | The name of the person's country |
| PER_ADR_DATE_FROM | The first date on which the person can be contacted at this address |
| PER_ADR_DATE_TO | The last date on which the person can be contacted at this address |
| PER_ADR_LINE_1 | The first line of the person's address |
| PER_ADR_LINE_2 | The second line of the person's address |
| PER_ADR_LINE_3 | The third line of the person's address |
| PER_ADR_PHONE_1 | The person's first contact number |
| PER_ADR_PHONE_2 | The person's second contact number |
| PER_ADR_PHONE_3 | The person's third contact number |
| PER_ADR_POSTAL_CODE | The person's postal code |
| PER_ADR_REGION_1 | The first line of the person's region |
| PER_ADR_REGION_2 | The second line of the person's region |
| PER_ADR_REGION_3 | The third line of the person's region |
| Database item | Description |
|---|---|
| PER_ADR_US_COUNTY | The person's county (US only) |
| PER_ADR_US_STATE | The person's state (US only) |
| PER_ADR_US_STATE_CODE | The person's state code (US only) |
| Database item | Description |
|---|---|
| PER_ADR_UK_COUNTY | The person's home county (UK only) |
| Database item | Description |
|---|---|
| PER_AGE | The person's age |
| PER_APPLICANT_NUMBER | The person's applicant number |
| PER_CURRENT_APP | Whether the person is a current applicant (yes/no) |
| PER_CURRENT_EMP | Whether the person is a current employee (yes/no) |
| PER_DATE_OF_BIRTH | The person's date of birth |
| PER_DATE_VERIFIED | The date the employee last verified his or her personal data |
| PER_DISABLED | Whether the person is disabled (yes/no) |
| PER_EMP_NUMBER | The person's employee number |
| PER_FIRST_NAME | The person's first name |
| PER_FULL_NAME | The person's full name |
| PER_KNOWN_AS | The person's preferred name |
| PER_LAST_NAME | The person's last name |
| PER_MAIL_DESTINATION | The person's mail destination |
| PER_MARITAL_STATUS | The person's marital status |
| PER_MIDDLE_NAMES | The person's middle names |
| PER_NATIONALITY | The person's nationality |
| PER_NATIONAL_IDENTIFIER | The person's national identifier |
| PER_PERSON_TYPE | Type of person - employee or applicant, for example |
| PER_PREV_LAST_NAME | The person's previous last name |
| PER_SEND_EXPENSES | Where to send the person's expenses (home/office) |
| PER_SEX | The person's sex |
| PER_SUFFIX | The person's name suffix |
| PER_TITLE | The person's title |
| PER_WORK_PHONE | The person's work telephone number |
| Database item | Description |
|---|---|
| REC_CURRENT_APP | Whether the recruiter is a current applicant (yes/no) |
| REC_CURRENT_EMP | Whether the recruiter is a current employee (yes/no) |
| REC_EMP_NUMBER | The recruiter's employee number |
| REC_GRADE | The recruiter's grade |
| REC_INT_ADDR_LINE | The recruiter's internal address |
| REC_JOB | The recruiter's job |
| REC_LOCATION | The recruiter's work location |
| REC_MANAGER | Whether the assignment is a managerial assignment (yes/no) |
| REC_ORG | The name of the recruiter's organization |
| REC_PERSON_TYPE | The recruiter's person type - employee or applicant, for example |
| REC_POSITION | The recruiter's position |
| REC_WORK_PHONE | The recruiter's work telephone number |
| Database item | Description |
|---|---|
| SUP_CURRENT_EMP | Whether the supervisor is a current employee (yes/no) |
| SUP_DATE_FROM | The date from which this supervisor information is effective |
| SUP_DATE_TO | The date to which this supervisor information is effective |
| SUP_EMP_NUMBER | The supervisor's employee number |
| SUP_GRADE | The supervisor's grade |
| SUP_INT_ADDR_LINE | The supervisor's internal address |
| SUP_JOB | The supervisor's job |
| SUP_LOCATION | The supervisor's work location |
| SUP_MANAGER | Whether the assignment is a managerial assignment (yes/no) |
| SUP_ORG | The supervisor's organization |
| SUP_PERSON_TYPE | The supervisor's person type |
| SUP_POSITION | The supervisor's position |
| SUP_WORK_PHONE | The supervisor's work telephone number |
| Database item | Description |
|---|---|
| SESSION_DATE | The effective date from FND_SESSIONS |
| SYSDATE | The system date |
| Previous | Next | Contents | Index | Navigation | Glossary | Library |