Database items解释

最新推荐文章于 2024-10-11 17:04:33 发布
最新推荐文章于 2024-10-11 17:04:33 发布
阅读量383 收藏
点赞数
文章标签： 数据库

Applicant Information

Database itemDescription
APL_DATE_ENDThe date the application ended
APL_DATE_RECEIVEDThe date the application was received

Employee Assignment Information

Database itemDescription
ASG_ASSIGNMENT_SEQUENCEThis is used as a default for assignment number
ASG_DATE_FROMThe date from which this assignment information is effective
ASG_DATE_TOThe date to which this assignment information is effective
ASG_EMPLOYMENT_CATEGORYThe employment category for the assignment
ASG_END_TIMEThe standard end time for the assignment
ASG_FREQThe frequency for which the assignment working hours are measured
ASG_GRADEThe employee's grade
ASG_GRADE_DATE_FROMThe date from which this assignment grade information is effective
ASG_GRADE_DATE_TOThe date to which this assignment grade information is effective
ASG_GROUPThe employee's group
ASG_HOURSThe standard number of working hours for the assignment
ASG_INT_ADDR_LINEThe internal address of the assignment
ASG_JOBThe employee's job
ASG_JOB_DATE_FROMThe date from which this assignment job information is effective
ASG_JOB_DATE_TOThe date to which this assignment job information is effective
ASG_LAST_CHANGE_REASONThe reason the salary was changed
ASG_LAST_PERFORMANCE_DATELast performance review date
ASG_LAST_PERFORMANCE_LOCATIONLast performance review location
ASG_LAST_PERFORMANCE_RATINGLast performance review rating
ASG_LAST_PERFORMANCE_TYPELast performance review type
ASG_LAST_PROC_PAYROLL_NAMEThe payroll name the assignment was last processed
ASG_LAST_PROC_PERIOD_IDThe time period ID the assignment was last processed
ASG_LAST_PROC_PERIOD_NAMEThe period name the assignment was last processed
ASG_LAST_PROC_PERIOD_NUMBERThe period number the assignment was last processed
ASG_LAST_PROPOSED_SALARY_CHANGEThe proposed salary chage
ASG_LAST_PROPOSED_SALARY_PERCENTThe proposed salary change as a percentage
ASG_LAST_SALARY_CHANGE_APPROVEDWhether the last proposed salary change has been approved
ASG_LAST_SALARY_DATEThe last salary change date
ASG_LOCATIONThe employee's location
ASG_LOC_INACTIVE_DATEThe date to which the location information is effective
ASG_MANAGERWhether the assignment is a managerial assignment (yes/no)
ASG_NEXT_PERFORMANCE_DATENext performance review date
ASG_NEXT_SALARY_DATEThe date of the next salary change
ASG_NUMBERThe assignment number
ASG_ORGThe employee's organization
ASG_ORG_DATE_FROMThe date from which assignment organization information is effective
ASG_ORG_DATE_TOThe date to which assignment organization information is effective
ASG_PAYROLLThe employee's payroll
ASG_PERFORMANCE_REVIEW_FREQUENCYThe performance review frequency for the assignment
ASG_PERFORMANCE_REVIEW_PERIODThe performance review frequency for the assignment
ASG_PER_STATUS_DPPersonal status for the assignment (as of Date Paid)
ASG_POSITIONThe employee's position
ASG_POS_DATE_FROMThe date from which this assignment position information is effective
ASG_POS_DATE_TOThe date to which this assignment position information is effective
ASG_POS_END_TIMEThe standard end time for the assignment position
ASG_POS_FREQThe frequency for which the assignment position's hours is measured
ASG_POS_HOURSThe standard number of working hours for the position
ASG_POS_PROB_PERIODThe probation period for the assignment position
ASG_POS_START_TIMEThe standard start time for the assignment position
ASG_PRIMARYWhether this is the employee's primary assignment (yes/no)
ASG_PROB_END_DATEThe probation period end date
ASG_PROB_PERIODThe assignment's probation period
ASG_PROB_UNITSThe units of the assignment's probation period
ASG_REC_FULL_NAMEThe full name for the recruiter
ASG_RELIEFThe relief position if the current position holder is absent
ASG_SALARYThe current salary for an employee
ASG_SALARY_BASISThe payment basis (i.e. frequency) for the assignment, e.g. monthly
ASG_SALARY_BASIS_CODEThe payment basis lookup code for the assignment
ASG_SALARY_BASIS_NAMEThe salary basis name for the assignment
ASG_SALARY_ELEMENTThe display element name
ASG_SALARY_ELEMENT_VALUE_NAMEThe display input value name
ASG_SALARY_GRADE_RATEThe display rate name
ASG_SALARY_RATE_BASISThe salary rate basis
ASG_SALARY_REVIEW_FREQUENCYThe salary review frequency for the assignment
ASG_SALARY_REVIEW_PERIODThe salary review period for the assignment
ASG_START_DATEThe start date of the assignment
ASG_START_TIMEThe standard start time for the assignment
ASG_STATUSThe primary status for the assignment
ASG_SUCCESSORThe position name that will succeed into this position
ASG_SUP_FULL_NAMEThe full name for the supervisor
ASG_TYPEWhether this is an employee or applicant assignment
ASG_VACANCYThe name of the vacancy applied for

Contact Addresses

Database itemDescription
CON_ADR_CITYThe name of the contact's town or city
CON_ADR_COUNTRYThe name of the contact's country
CON_ADR_DATE_FROMThe first date on which the contact can be contacted
CON_ADR_DATE_TOThe last date on which the contact can be contacted
CON_ADR_LINE_1The first line of the contact's address
CON_ADR_LINE_2The second line of the contact's address
CON_ADR_LINE_3The third line of the contact's address
CON_ADR_PHONE_1The contact's first telephone number
CON_ADR_PHONE_2The contact's second telephone number
CON_ADR_PHONE_3The contact's third telephone number
CON_ADR_POSTAL_CODEThe contact's postal code
CON_ADR_REGION_1The first line of the contact's region
CON_ADR_REGION_2The second line of the contact's region
CON_ADR_REGION_3The third line of the contact's region

Contact Information

Database itemDescription
CON_AGEThe contact's age
CON_APP_NUMBERThe contact's applicant number
CON_CURRENT_APPWhether the contact is a current applicant (yes/no)
CON_CURRENT_EMPWhether the contact is a current employee (yes/no)
CON_DATE_OF_BIRTHThe contact's date of birth
CON_DISABLEDWhether the contact is disabled (yes/no)
CON_EMP_NUMBERThe contact's employee number
CON_END_DATEThe date to which this contact information is effective
CON_FIRST_NAMEThe contact's first name
CON_FULL_NAMEThe contact's full name
CON_KNOWN_ASThe contact's preferred name
CON_LAST_NAMEThe contact's last name
CON_MARITAL_STATUSThe contact's marital status
CON_MIDDLE_NAMESThe contact's middle names
CON_NATIONALITYThe contact's nationality
CON_PERSON_TYPEThe contact's person type - employee or applicant, for example
CON_RELATIONSHIPThe relationship of the contact to the employee
CON_SEXThe contact's sex
CON_START_DATEThe date from which this contact information is effective
CON_TITLEThe contact's title
CON_WORK_PHONEThe contact's work telephone number

Employee Hire Information

Database itemDescription
EMP_HIRE_DATEThe employee's hire date
EMP_LAST_PROCESS_DATEThe date the employee was last processed
EMP_LEAVING_REASONThe reason the employee left
EMP_TERM_ACCEPTED_BYThe person who accepted the employee's notice
EMP_TERM_DATEThe employee's termination date

Location Details

Database itemDescription
LOC_ADR_LINE_1The first line os the assignment's work address
LOC_ADR_LINE_2The second line of the assignment's work address
LOC_ADR_LINE_3The third line of the assignment's work address
LOC_ADR_POSTAL_CODEThe postal code for the assignment's work address
LOC_ADR_REGION_1The first line of the assignment's region
LOC_ADR_REGION_2The second line of the assignment's region
LOC_ADR_REGION_3The third line of the assignment's region
LOC_ADR_PHONE_1The assignment's first work telephone number
LOC_ADR_PHONE_2The assignment's second work telephone number
LOC_ADR_PHONE_3The assignment's third work telephone number
LOC_ADR_CITYThe town or city where the assignment works
LOC_ADR_COUNTRYThe country where the assignment works

Work Address Details (US only)

Database itemDescription
LOC_ADR_US_COUNTYThe assignment's work county (US only)
LOC_ADR_US_STATEThe assignment's work state (US only)
LOC_ADR_US_STATE_CODEThe assignment's work state code (US only)

Work Address Details (UK only)

Database itemDescription
LOC_ADR_UK_COUNTYThe assignment's work county (UK only)

Payroll Details

Database itemDescription
PAY_PERIODS_PER_YEARThe number of pay periods in the year
PAY_PROC_PERIOD_CUT_OFF_DATEThe cut off date for the payroll period
PAY_PROC_PERIOD_DATE_PAIDThe date the payroll was paid
PAY_PROC_PERIOD_DIRECT_DEPOSIT_DATEThe direct deposit date for the payroll period
PAY_PROC_PERIOD_END_DATEThe end date of the payroll period
PAY_PROC_PERIOD_IDThe ID of the time period for the payroll
PAY_PROC_PERIOD_NAMEThe period name for the payroll
PAY_PROC_PERIOD_NUMBERThe current period number for the payroll
PAY_PROC_PERIOD_PAY_ADVICE_DATEThe pay advice date for the payroll period
PAY_PROC_PERIOD_START_DATEThe start date of the payroll period

People Addresses

Database itemDescription
PER_ADR_CITYThe name of the person's town or city
PER_ADR_COUNTRYThe name of the person's country
PER_ADR_DATE_FROMThe first date on which the person can be contacted at this address
PER_ADR_DATE_TOThe last date on which the person can be contacted at this address
PER_ADR_LINE_1The first line of the person's address
PER_ADR_LINE_2The second line of the person's address
PER_ADR_LINE_3The third line of the person's address
PER_ADR_PHONE_1The person's first contact number
PER_ADR_PHONE_2The person's second contact number
PER_ADR_PHONE_3The person's third contact number
PER_ADR_POSTAL_CODEThe person's postal code
PER_ADR_REGION_1The first line of the person's region
PER_ADR_REGION_2The second line of the person's region
PER_ADR_REGION_3The third line of the person's region

Home Address Details (US only)

Database itemDescription
PER_ADR_US_COUNTYThe person's county (US only)
PER_ADR_US_STATEThe person's state (US only)
PER_ADR_US_STATE_CODEThe person's state code (US only)

Home Address Details (UK only)

Database itemDescription
PER_ADR_UK_COUNTYThe person's home county (UK only)

People Information

Database itemDescription
PER_AGEThe person's age
PER_APPLICANT_NUMBERThe person's applicant number
PER_CURRENT_APPWhether the person is a current applicant (yes/no)
PER_CURRENT_EMPWhether the person is a current employee (yes/no)
PER_DATE_OF_BIRTHThe person's date of birth
PER_DATE_VERIFIEDThe date the employee last verified his or her personal data
PER_DISABLEDWhether the person is disabled (yes/no)
PER_EMP_NUMBERThe person's employee number
PER_FIRST_NAMEThe person's first name
PER_FULL_NAMEThe person's full name
PER_KNOWN_ASThe person's preferred name
PER_LAST_NAMEThe person's last name
PER_MAIL_DESTINATIONThe person's mail destination
PER_MARITAL_STATUSThe person's marital status
PER_MIDDLE_NAMESThe person's middle names
PER_NATIONALITYThe person's nationality
PER_NATIONAL_IDENTIFIERThe person's national identifier
PER_PERSON_TYPEType of person - employee or applicant, for example
PER_PREV_LAST_NAMEThe person's previous last name
PER_SEND_EXPENSESWhere to send the person's expenses (home/office)
PER_SEXThe person's sex
PER_SUFFIXThe person's name suffix
PER_TITLEThe person's title
PER_WORK_PHONEThe person's work telephone number

Recruiter Information

Database itemDescription
REC_CURRENT_APPWhether the recruiter is a current applicant (yes/no)
REC_CURRENT_EMPWhether the recruiter is a current employee (yes/no)
REC_EMP_NUMBERThe recruiter's employee number
REC_GRADEThe recruiter's grade
REC_INT_ADDR_LINEThe recruiter's internal address
REC_JOBThe recruiter's job
REC_LOCATIONThe recruiter's work location
REC_MANAGERWhether the assignment is a managerial assignment (yes/no)
REC_ORGThe name of the recruiter's organization
REC_PERSON_TYPEThe recruiter's person type - employee or applicant, for example
REC_POSITIONThe recruiter's position
REC_WORK_PHONEThe recruiter's work telephone number

Supervisor Information

Database itemDescription
SUP_CURRENT_EMPWhether the supervisor is a current employee (yes/no)
SUP_DATE_FROMThe date from which this supervisor information is effective
SUP_DATE_TOThe date to which this supervisor information is effective
SUP_EMP_NUMBERThe supervisor's employee number
SUP_GRADEThe supervisor's grade
SUP_INT_ADDR_LINEThe supervisor's internal address
SUP_JOBThe supervisor's job
SUP_LOCATIONThe supervisor's work location
SUP_MANAGERWhether the assignment is a managerial assignment (yes/no)
SUP_ORGThe supervisor's organization
SUP_PERSON_TYPEThe supervisor's person type
SUP_POSITIONThe supervisor's position
SUP_WORK_PHONEThe supervisor's work telephone number

Date Information

Database itemDescription
SESSION_DATEThe effective date from FND_SESSIONS
SYSDATEThe system date


针对database item打个比方，在payroll模块之中定义assignment set的时候，如果使用criteria作为过滤条件，那么过滤条件就是依照database item的取值特征来过滤。

举例：assignment set中只包括这样的employee：employee所在部门名字为DEPT1的那些员工，那么criteria就应该是&ASG_ORG LIKE DEPT1。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25441646/viewspace-691790/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25441646/viewspace-691790/

comwjnweyl4433
关注
Oracle Database常见存储用语Terms
weixin_33845881的博客
11-23 59
Oracle Database常见存储用语Terms,如下： ACD = Active Change Directory ACFS = ASM Cluster File System ADDM = Automatic Database Diagnostic Monitor ADR = Automatic Diagnostic Repository ADVM = ASM Dy...
MySQL {term}.format(term=terms)解决筛选问题
无痕的博客
04-07 399
问题：数据表中某一字段(假设为os）的存值是各个主机的操作系统，现在想在页面中归纳操作系统，并根据归纳后的操作系统类别进行搜索，搜索项有“CentOS”、“Ubuntu”、“RedHat”、“SUSE”、“其他”，“所有”，对应的前端设计传值为“CentOS”、“Ubuntu”、“RedHat”、“SUSE”，“others”，“” 数据库数据内容： mysql> ...
mysql基础知识之创建数据库，表操作，增加数据，更新数据，删除数据，查询数据
yizhangzzzz的博客
10-27 489
MySQL基础知识 一.数据库操作 1.数据库创建 命令行创建 mysql>create database 数据库名称 使用navicat 2.查看当前都有哪些数据库 show databases; 3.删除数据库 drop database 数据库名 二.表操作 1.创建表 create table 表名 创建一个空表格 create table students( class varchar(50), name varchar(50) ); 创建检查表 create table che
activiti7关联mysql_学习笔记：一个MySQL实例有多个Activiti数据库问题
weixin_28987001的博客
03-05 536
学习笔记：一个MySQL实例有多个Activiti数据库问题使用SpringBoot + activiti6 搭建审批流项目,数据库使用的是MySQL.且我的数据库下存在多个activiti相关的数据库 schema.org.activitiactiviti-spring-boot-starter-basic6.0.0配置文件spring.datasource.driver-class-name=...
OpenDatabase
03-07
应该有一个名为OpenDatabase的文件夹，该文件夹内当前有两个文件夹/ Items /和/ Recipes /。 在这些文件夹中是您现在可以修改的JSON文件。 配置文件BepInEx / config / Botan.OpenDatabase.cfg 启用或禁用国防部。...
tarkov-database:Tarkov数据库的TypeScript SDK
04-03
Tarkov-database项目提供了一个专门针对这款游戏的TypeScript SDK，使得开发者可以更加便捷地访问和操作Tarkov的相关数据。本文将深入探讨这个SDK的特性、使用方法以及它如何为TypeScript开发者带来便利。 首先，...
Random-Selector-2.0.rar_Database1.laccdb_random
09-24
Looking for a way to Randomly Select items your Database? This is a simple random selector that can load items your Access Database in a random way. This uses an OLEDB connection an of course an ...
alldatabase_world_of_Wc_worldofwarcraft_database_
09-30
例如，角色表（Characters）存储玩家角色的基本信息，装备表（Items）记录所有装备的属性，任务表（Quests）包含任务描述和目标，等等。 二、alldatabase_world_of_Wc.sql文件解析 1. SQL脚本：alldatabase_world_...
mysql数据库设置
lwguang0612的博客
03-08 195
character_set_server：默认的内部操作字符集character_set_client：客户端来源数据使用的字符集character_set_connection：连接层字符集 删除列要用drop选b 删除表要用DROP TABLE选d
Druid setSchema无效
u011470905的博客
07-06 2164
Druid setSchema无效 记一次springboot 集成Druid setSchema无效的问题查找 环境 我采用的是 druid-spring-boot-starter 1.2.6 版本，由于是SaaS项目，采用了多租户设计。数据库是MySQL8 每一个租户都是一个schema（即每个租户一个库）。 我的设计是想通过mybatis的prepare拦截器。拦截所有的数据库操作然后根据用户token获取到租户的schema然后通过如下代码设置schema： @Override public Obj
item的使用以及SQLite数据库增删改查
QI760549741的博客
05-06 1165
前言该程序有两个版本，1是实现item使用，以及界面的增删；2增加了SQLite数据库的使用，可以保存数据。一、主要知识点1.item布局主要运用ListView <ListView android:id="@+id/accountLV" android:layout_width="match_parent" android:layout_hei
JDBC元数据操作（一）-- DatabaseMetaData接口详解
热门推荐
雾里看花
01-27 4万+
1. 前言     在JDBC技术规范中，提供了Connection，Statement,ResultSet这三个开发过程中经常用到的接口。针对与每个接口，JDBC规范提供了相应的接口描述对象，也就是xxxMetaData系列描述对象。DatabaseMetaData和ResultSetMetaData就是两个常用的获取数据库元数据相关信息的接口，本文只讲解DatabaseMetaData接口获
EBS描述性弹性域及键弹性域总结
weixin_30699831的博客
08-01 673
一.描述性弹性域 　　前言介绍：　　　　 　　　　描述性弹性域的实质就是系统预留自定字段，系统可以使用说明性弹性域来获取业务所特有的重要附加信息。系统可能自定义说明性弹性域，以显示存储更多信息的字段，提供一套完整的“自定义”机制，可以用值集来验证字段、字段间可以设置依赖关系等等。 　　1.注册表和字段到EBS（记得COMMIT）：　　 　　　　说明： 　　　　　　注册表： ...
查看mysql有多个实例_一个MySQL实例有多个Activiti数据库问题
weixin_30588381的博客
02-05 191
使用SpringBoot + activiti6 搭建审批流项目,数据库使用的是MySQL.且我的数据库下存在多个activiti相关的数据库 schema.org.activitiactiviti-spring-boot-starter-basic6.0.0复制代码配置文件spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driversp...
Elasticsearch查询规则：match和term
ChasingdreamLY的博客
04-17 1051
es种有两种查询模式，一种是像传递URL参数一样去传递查询语句，被称为简单搜索或查询字符串(query string)搜索，比如GET /megacorp/employee/_search //查询全部员工 GET /megacorp/employee/_search?q=last_name:Smith //查询last_name为Smith的员工另外一种是通过DSL语句来进行查询，被称为DSL查询
MySQL数据库的详细学习步骤
最新发布
2401_87352036的博客
10-11 1109
MySQL数据库的详细学习步骤可以归纳为以下几个阶段，每个阶段都包含了特定的学习内容和目标。
PyQt 的Tree Widget中拖放和点击的异常行为
weixin_44617651的博客
10-10 472
在 PyQt 的 ​​QTreeWidget​​ 中，如果你遇到 拖放 和 点击 的异常行为，可能是由于信号处理、事件拦截、拖放设置或树结构配置等问题导致的。以下是一些可能的常见问题和解决方案。
解释一下代码 void ItemDB_Sort(int sort_method, int sort_dir) /* 对数据库中的物品进行排序。 sort_method是排序方法，可以取下列值之一： SORT_BY_NUMBER, SORT_BY_NAME, SORT_BY_QUANTITY sort_dir是排序方向，可以取下列值之一： SORT_ASCENDING, SORT_DESCENDING */ { int (*compare_func)(const void *, const void *); switch(sort_method) { case SORT_BY_NUMBER: if(sort_dir == SORT_ASCENDING) compare_func = CompareByNumber_Ascending; else compare_func = CompareByNumber_Descending; //QuickSort(item_database->number , //num_items , sizeof(int) , //compare_func); break; case SORT_BY_NAME: if(sort_dir == SORT_ASCENDING) compare_func = CompareByName_Ascending; else compare_func = CompareByName_Descending; //QuickSort(item_database->name , //num_items , strlen(item_database->name) , // compare_func); break; case SORT_BY_QUANTITY: if(sort_dir == SORT_ASCENDING) compare_func = CompareByQuantity_Ascending; else compare_func = CompareByQuantity_Descending; //QuickSort(item_database->quantity , //num_items , sizeof(int) , // compare_func); break; default:return; } QuickSort(item_database, num_items,sizeof(struct Item),compare_func); }
05-18
这段代码是一个对数据库中的物品进行排序的函数。函数接收两个参数，一个是sort_method，表示排序的方法，可以通过SORT_BY_NUMBER、SORT_BY_NAME和SORT_BY_QUANTITY这三个宏来指定按照编号、名称或数量排序；另一个是sort_dir，表示排序的方向，可以通过SORT_ASCENDING和SORT_DESCENDING这两个宏来指定升序或降序。 函数内部根据sort_method的值选择相应的比较函数compare_func，这些比较函数分别按照不同的排序方式进行比较。然后调用一个QuickSort函数来实现排序，QuickSort函数的参数包括要排序的数据指针、数据个数、每个数据项的大小和比较函数指针。 需要注意的是，这段代码中注释掉的部分是使用标准库函数qsort来实现排序的代码，而现在使用的是一个自定义的快速排序函数QuickSort。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值